Range("A1").Select

[Rick]

Hi,

I know how to get the cuser to move to cell A1, but how do I get the
screen to display A1.

My problem - I'm at cell Z100 and I use Range("A1").Select BUT it
returns the cursor to A1, but leaves me looking at the middle of the
spreadsheet at Z100 still.

How do I get the screen to display the the page with A1 reset back to
the top left?

Tks,
Kaye

 

[OssieMac]

Hi Rick

ActiveWindow.ScrollRow = 1
ActiveWindow.ScrollColumn = 1

Regards,

OssieMac

 

[Rick]

Thanks OssieMac!

Kaye
(on Rick's computer)

Hi Rick

ActiveWindow.ScrollRow = 1
ActiveWindow.ScrollColumn = 1

Regards,

OssieMac

 

[Tom Ogilvy]

application.goto Range("A1"), scroll:=True

is another way.