Hi Ashman
help in ver 2003 gives the following example:
---
Application.Goto Reference:=Worksheets("Sheet1").Range("A154"), scroll:=True
---
which works fine for me. Does this do what you want?
Cheers
JulieD
"Ashman" wrote in message
...
Hi all,
I am trying to use Excel VB to select a cell on a worksheet and make it
visible, ie not just selecting it, but moving the screen to show that
selected cell.
I think this is application.goto function, but not sure how to use it,
reference books letting me down.
Can someone help me?