View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JulieD JulieD is offline
external usenet poster
 
Posts: 618
Default 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" 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?