Detect # scrolled-out rows and column
 

Hi:
My spreadsheet data span over 200 columns and 200 rows. I have split
the spreadsheet so that headers (Row A) and lables (Column 1) are in
"frozen" top and left panes. The data then starts in cell B2.

When I scroll down or to the right, the value in C2 necessarily
"disappears" behind the top or left pane.

Is it any way I can programatically detect and display how many rows
and columns are hidden behind the top or left pane?

I Also would like to find a similar function, telling how many rows or
columns are hidden under or to the right of the open window...

Toreadore


--
toreadore
------------------------------------------------------------------------
toreadore's Profile: http://www.excelforum.com/member.php...o&userid=35850
View this thread: http://www.excelforum.com/showthread...hreadid=557230

Detect # scrolled-out rows and column
 

Toreadore,
Something like:
ThisWorkbook.Windows(1).Panes(4).VisibleRange.Addr ess

NickHK

"toreadore" wrote
in message ...

Hi:
My spreadsheet data span over 200 columns and 200 rows. I have split
the spreadsheet so that headers (Row A) and lables (Column 1) are in
"frozen" top and left panes. The data then starts in cell B2.

When I scroll down or to the right, the value in C2 necessarily
"disappears" behind the top or left pane.

Is it any way I can programatically detect and display how many rows
and columns are hidden behind the top or left pane?

I Also would like to find a similar function, telling how many rows or
columns are hidden under or to the right of the open window...

Toreadore


--
toreadore
------------------------------------------------------------------------
toreadore's Profile:
http://www.excelforum.com/member.php...o&userid=35850
View this thread: http://www.excelforum.com/showthread...hreadid=557230