| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Detect missing rows | Excel Programming | |||
| How to detect changes in a column? | Excel Discussion (Misc queries) | |||
| How to detect and view more than 65,536 rows when opening a DBF | Excel Programming | |||
| Event to trigger when form is scrolled | Excel Programming | |||
| how to detect added or deleted rows in compare | Excel Programming | |||
![toreadore[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
