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

"toreadore" <toreadore.2a7kjp_1151659505.2335@excelforum-nospam.com> wrote
in message news:toreadore.2a7kjp_1151659505.2335@excelforum-nospam.com...
>
> 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
>