Determine upper visible corner of sheet

[John Michl]

Note: Thought I posted this over an hour ago but something must have
gone wrong. Advance apoligies if this turns out to be a double post.

I know how to find the address of the current "Active Cell". However,
sometimes the active cell is not visible on the screen. How can I
determine the upper left most visible cell (not including any cells
included in the frozen panes?

Basically, I'm trying to capture the row number of the visible row (not
necessarilly active) so that I can navigate across the sheet but keep
that row visible.

Any ideas?

Thanks,

John

 

[Ivan Raiminius]

Hi John,

try something like this:
application.Windows(1).VisibleRange.Address

regards,
Ivan

 

[John Michl]

Thanks, Ivan.

That did the trick.

- John