How to Adjust the Screen?

[hce]

Dear All

I have a macro to select a particular cell in a particular worksheet..
for eg i want the cursor to be at cell A500 in sheet1... the macro doe
the job... but the screen does not move in tandem... how can i get th
macro to "move" the screen as well so that when i open the worksheet
will see cell A500 immediately without me scrolling down...?

cheer

 

[Don Guillett]

try
Sub gothere()
Application.Goto Range("a500"), Scroll:=True
End Sub

 

[A.W.J. Ales]

Hce,

I suppose you now use something like : RANGE("A5000").SELECT or
CELLS(5000,1).SELECT

Use instead : Application.Goto Reference:="R5000C1"

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[hce]

Thank you so much to all who helped... i really appreciate it...
cheer