Where am I ?

[Gary''s Student]

Given that the user has arbitrarily scrolled up and down and right and left,
what is the address of the top, leftmost cell ? That is, the first visible
cell in the Excel window ?

 

[Peter T]

MsgBox ActiveWindow.VisibleRange(1, 1).Address

Regards,
Peter T

 

[Jim Thomlinson]

MsgBox ActiveWindow.ActivePane.VisibleRange.Cells(1, 1).Address

 

[Rick Rothstein \(MVP - VB\)]

I think this is what you want...

TopRow = ActiveWindow.Panes(ActiveWindow.Panes.Count).ScrollRow
LeftCol = ActiveWindow.Panes(ActiveWindow.Panes.Count).ScrollColumn

While you can get any pane's scrolled row/column, I assumed that, if there
were one or more split panes, you would want the right, bottom or
right-bottom most one (hence the reference to the Count property).

Rick

 

[Gary Keramidas]

another way i always use:

activewindow.VisibleRange.Range("A1").address

 

[Rick Rothstein \(MVP - VB\)]

I guess, in light of the other posts, if you wanted the address of the
top/left cell in the bottom, right or bottom-right most pane (when there is
one or more panes showing), you could use this...

TopLeftCellAddress = Split(ActiveWindow.Panes(ActiveWindow.Panes.Count)._
VisibleRange.Address, ":")(0)

Rick

 

[Gary''s Student]

Thanks
--
Gary''s Student - gsnu200781

MsgBox ActiveWindow.VisibleRange(1, 1).Address

Regards,
Peter T

 

[Gary''s Student]

Thanks
--
Gary''s Student - gsnu200781

MsgBox ActiveWindow.ActivePane.VisibleRange.Cells(1, 1).Address

 

[Gary''s Student]

Thanks
--
Gary''s Student - gsnu200781

another way i always use:

activewindow.VisibleRange.Range("A1").address

 

[Gary''s Student]

Thanks again
--
Gary''s Student - gsnu200781

I think this is what you want...

TopRow = ActiveWindow.Panes(ActiveWindow.Panes.Count).ScrollRow
LeftCol = ActiveWindow.Panes(ActiveWindow.Panes.Count).ScrollColumn

While you can get any pane's scrolled row/column, I assumed that, if there
were one or more split panes, you would want the right, bottom or
right-bottom most one (hence the reference to the Count property).

Rick