Find

[Tim]

Can I find a cell address in another sheet in a book
without acvtivating the other sheet?

Thanks

 

[Tom Ogilvy]

Sure - you just need to qualify where you want to look - a simplified
example.

With worksheets("sheet9")
set rng = .cells.find(What:=Target)
End With
if not rng is nothing then
msgbox rng.Address(external:=True)
End if