请教,在Excel2003 VBA中,如何查找某一单元格中指定的字符串?谢谢。答:Cells.Find(What:=Cells(1, 1), After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _, MatchByte:=False, SearchFormat:=False).Activate Cells(1, 1)代表单元格A1,你可以替换成必要指定的单元格。
求助excel,用VBA如何做条件查找。查找某一个单元格内容,并打开_百度...答:Dim PH As String, Name1 As String, Name2 As String, S As String Dim ob1 As Object, Wb As Workbook Dim G As Integer, N As Integer, N1 As Integer PH = InputBox("请输入要查找字符的文件夹:", "提示信息", "d:\my")S = InputBox("请输入要查找的字符:", "提示信息")P...