Application.GoTo

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" <Ashman@discussions.microsoft.com> wrote in message
news:91C2FAA5-1D04-4C07-9E90-A33D6B4E8A29@microsoft.com...
> 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" <Ashman@discussions.microsoft.com> wrote in message
> news:91C2FAA5-1D04-4C07-9E90-A33D6B4E8A29@microsoft.com...
> > 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?
>
>
>