choosing cell to top left of visible window

's Computer Specifications

Excel 2003 and 2007 > Because displays vary, when I click a macro button to
go to a different part of the sheet, I want to choose a cell in column A so
that it appears at the upper left of the current window. I can't seem to get
it to work in
Excel 2003 - the selected cell appears some where in the middle.

's Computer Specifications

maybe this will work for you.

type this in the immediate window

?cells(Activewindow.Scrollrow,activewindow.ScrollColumn).address

--

Gary Keramidas
Excel 2003

"AZSteve" <(E-Mail Removed)> wrote in message
news:A1133411-CDBA-4179-9ACB-(E-Mail Removed)...
> Excel 2003 and 2007 > Because displays vary, when I click a macro button
> to
> go to a different part of the sheet, I want to choose a cell in column A
> so
> that it appears at the upper left of the current window. I can't seem to
> get
> it to work in
> Excel 2003 - the selected cell appears some where in the middle.

's Computer Specifications

Try it this way...

Application.Goto Range("A100"), True

Just change the "A100" to the address of the cell you want to place in the
upper, left corner of the window.

--
Rick (MVP - Excel)

"AZSteve" <(E-Mail Removed)> wrote in message
news:A1133411-CDBA-4179-9ACB-(E-Mail Removed)...
> Excel 2003 and 2007 > Because displays vary, when I click a macro button
> to
> go to a different part of the sheet, I want to choose a cell in column A
> so
> that it appears at the upper left of the current window. I can't seem to
> get
> it to work in
> Excel 2003 - the selected cell appears some where in the middle.

's Computer Specifications

i thought you wanted to identify the cell that is in the upper left corner
of the sheet.

--

Gary Keramidas
Excel 2003

"Gary Keramidas" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> maybe this will work for you.
>
> type this in the immediate window
>
> ?cells(Activewindow.Scrollrow,activewindow.ScrollColumn).address
>
> --
>
>
> Gary Keramidas
> Excel 2003
>
>
> "AZSteve" <(E-Mail Removed)> wrote in message
> news:A1133411-CDBA-4179-9ACB-(E-Mail Removed)...
>> Excel 2003 and 2007 > Because displays vary, when I click a macro button
>> to
>> go to a different part of the sheet, I want to choose a cell in column A
>> so
>> that it appears at the upper left of the current window. I can't seem to
>> get
>> it to work in
>> Excel 2003 - the selected cell appears some where in the middle.
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
scroll so that the upper left cell in a range moves to the upper left of the active window	Andre	Microsoft Excel Programming	6	14th Nov 2008 09:33 PM
left align active column/cell in window	=?Utf-8?B?TkpT?=	Microsoft Excel Programming	5	10th Jul 2007 05:08 PM
Reference bottom left cell in a visible range	kylekelsch@hotmail.com	Microsoft Excel Programming	1	22nd Mar 2007 04:50 PM
scroll window to display selected cell in visible area?	Kate	Microsoft Excel Programming	5	3rd Jan 2006 03:38 PM
How to make sure a Cell is within the current visible window's ran	=?Utf-8?B?T0tMb3Zlcg==?=	Microsoft Excel Programming	2	13th Jul 2005 01:38 PM