Hello to all.
I would like to ask you if you find someone who can help me with these two macros that work very well but for certain things. So because I do not understand many will not explain what the problem is:
The first is made so that the popup window to search for a word in countless workbooks, it does but only in the open sheet of the workbook. So you can be less that the revised starting from the first workbook, going through all the paper then goes to the second sheet and check all the way to the end?
I want to thank you in advance for all your help.Code:Sub SearchBookss() SearchWord = InputBox("Enter the string to search for") For i = 1 To Workbooks.Count Workbooks(i).Activate Range("A1").Activate FindAnother: Set WordAddress = Cells.Find(What:=SearchWord, after:=ActiveCell, LookIn:=xlFormulas, lookat:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False) If WordAddress Is Nothing Then MsgBox ActiveWorkbook.Name & Chr(13) & "Search string not found" Else: If WordAddress.Address = CheckCell Then GoTo NextBook If ActiveCell.Address = "$A$1" Then CheckCell = WordAddress.Address Address = WordAddress.Address MsgBox ActiveWorkbook.Name & Chr(13) & Address Range(Address).Activate GoTo FindAnother End If NextBook: Next i End Sub




Reply With Quote
Bookmarks