I want this VBA to work like its working but I need to search multiple sheets except the sheet it’s getting its value from
I have master sheet which have all values, I want macro to search active cell value from all sheets except master sheet.
Please help
Sub FindApp()
Dim ws As Worksheet, Found As Range
lookfor = Selection.Value
Sheets("Claims").Activate
Cells.Find(What:=lookfor, After:=ActiveCell, LookIn:=xlValues, _
LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False).Select
End Sub
I have master sheet which have all values, I want macro to search active cell value from all sheets except master sheet.
Please help
Code:
&
Sub FindApp()
Dim ws As Worksheet, Found As Range
lookfor = Selection.Value
Sheets("Claims").Activate
Cells.Find(What:=lookfor, After:=ActiveCell, LookIn:=xlValues, _
LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False).Select
End Sub