Macro Find
target = worksheets(1).Range("A1").value
set rng = worksheets(2).Cells.Find(target)
if not rng is nothing then
application.goto rng, true
else
msgbox "Not found"
End if
--
Regards,
Tom Ogilvy
"JavyD" wrote in message
...
Hello guys,
Is there any possible way, that with a macro, with a button on sheet one,
can look at an item # in sheet one, say cell A1, and look for that item #
and
take me there on sheet 2?
Pretty please!
|