EXCEL: Position sheet view in window ???
Esteemed Forum Participants and Lurkers:
==============================
**** Excel 97 ****
I am trying to position a worksheet in a window. I have five header rows and one column frozen (Menu Bar > Window > Freeze Panes) and I can search and find the current date in the left column. What I want to do is to make the row for the CURRENT DATE the FIRST ROW viewed under the frozen pane rows. I am doing this in an "Auto_Open" macro to open the workbook with the optimal view for the user. I want to immediately view as much data as possible starting from the selected date, and data from previous dates is worthless (to view - don't suggest deleting it!).
I can get close ... I select the bottom date cell in the sheet, and then walk up the sheet selecting cells until I get to the current date. This only guarantees that the selected cell is within the viewing area ... but I want it at the top of the moveable viewing pane just like I can accomplish by cliking the scroll bar 'up arrow" with the mouse.
Does anyone have any idea as to how to accomplish this?
Reply With Quote