Determine upper visible corner of sheet
 

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

Determine upper visible corner of sheet
 

Hi John,

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

regards,
Ivan

Determine upper visible corner of sheet
 

Thanks, Ivan.

That did the trick.

- John