Detect # scrolled-out rows and column

[toreadore]

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

 

[NickHK]

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

NickHK