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?

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?

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

"JulieD" wrote:

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?