• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA to find active cell value from mutiple sheets

ALAMZEB

Member
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

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
 
if its found than it should take me to that location.i dont think there would be any duplicated in other sheets.
 
if not found in any sheet than a message saying that its not found & if found in more sheets than do take me to first location it found but gives a message that a duplicate is found
 
Back
Top