Application.GoTo

[Guest]

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?

 

[JulieD]

Hi Ashman

help in ver 2003 gives the following example:

 

[Guest]

Many thanks, worked very well and does exactly what I wanted.