I have Worsheets(1) is where the searching occurs. Column E of Worksheets(2 to n) will be searched.
In worksheet(1) I have a textbox the receives the string to be searched.
Code:countWS = ThisWorkbook.Sheets.Count resultRow = 5 For cursor = 2 To countWS 'seach and paste each result on Worksheets(1).Cells(resultRow, 2) 'resultRow = resultRow +1 Next cursor





Reply With Quote
