How to Adjust the Screen?

H

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
 
Top