Find
 

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

Thanks

Find
 

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
--
Regards,
Tom Ogilvy

"Tim" wrote in message
...
Can I find a cell address in another sheet in a book
without acvtivating the other sheet?

Thanks