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