Range("A1").Select
 

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

Range("A1").Select
 

Hi Rick

ActiveWindow.ScrollRow = 1
ActiveWindow.ScrollColumn = 1

Regards,

OssieMac

"Rick" wrote:

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

Range("A1").Select
 

Thanks OssieMac!

Kaye
(on Rick's computer)

On Thu, 11 Oct 2007 00:26:02 -0700, OssieMac
wrote:

Hi Rick

ActiveWindow.ScrollRow = 1
ActiveWindow.ScrollColumn = 1

Regards,

OssieMac

"Rick" wrote:

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

Range("A1").Select
 

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

is another way.

--
Regards,
Tom Ogilvy


"Rick" wrote:


Thanks OssieMac!

Kaye
(on Rick's computer)

On Thu, 11 Oct 2007 00:26:02 -0700, OssieMac
wrote:

Hi Rick

ActiveWindow.ScrollRow = 1
ActiveWindow.ScrollColumn = 1

Regards,

OssieMac

"Rick" wrote:

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