I want to be able to search specific sheets within a workbook to make it more efficient than searching through all sheets since I know some of them contain irrelevant information. The current code I have searches through all sheets within the workbook:
thanks a lot.
Code:
For Each ws In wbSource.Worksheets
With wbSource.Sheets(ws.Name).Cells
Application.FindFormat.NumberFormat = "General"
Set curCell = .Find(What:=mySearch, LookIn:=xlValues, LookAt:=xlPart, _
MatchCase:=False, SearchOrder:=xlByColumns)
If Not curCell Is Nothing Then
' do stuff
End If
End With
Next ws
thanks a lot.