Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying active cell in particular position on screen
Hi, I use a macro to select a cell. How can I make sure this cell is positioned as the first cell outside of the frozen panes? Matt |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying active cell in particular position on screen
By "outside of the frozen panes" I assume you mean the cell in top, left
position of the non-frozen area. If so, you can use this line of code to select that cell... Cells(ActiveWindow.SplitRow + 1, ActiveWindow.SplitColumn + 1).Select Rick "MJKelly" wrote in message ... Hi, I use a macro to select a cell. How can I make sure this cell is positioned as the first cell outside of the frozen panes? Matt |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying active cell in particular position on screen
Rick,
I don't want to select the cell just outside of the frozen pane area, I want the selected cell (selected by a macro) to become the first vieweable cell outside of the frozen pane area. In other words, I want to have a given column of data to be shown and everything to the left of this column to be hidden behind my frozen pane. Hope this makes sense? Matt |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying active cell in particular position on screen
Set the ScollColumn property of the ActiveWindow to the column number you
want butted up against the frozen pane. For example... ActiveWindow.ScrollColumn = ActiveCell.Column Rick "MJKelly" wrote in message ... Rick, I don't want to select the cell just outside of the frozen pane area, I want the selected cell (selected by a macro) to become the first vieweable cell outside of the frozen pane area. In other words, I want to have a given column of data to be shown and everything to the left of this column to be hidden behind my frozen pane. Hope this makes sense? Matt |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying active cell in particular position on screen
Excellent.
Thanks very much. Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get the correct active Cell position in Worksheet_Change | Excel Programming | |||
Active cell position for macro | Excel Worksheet Functions | |||
Position of Cell on Screen | Excel Programming | |||
Move Cell to Top/Left Position on Screen | Excel Programming | |||
Active Cell Position Using Go To Or Hyperlink | Excel Programming |