| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA equiv. of Ctrl-Home w/Freeze Panes?
Thanks,
George |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA equiv. of Ctrl-Home w/Freeze Panes?
May have answered my own question:
ActiveSheet.Cells(ActiveWindow.SplitRow+1, ActiveWindow.SplitColumn+1).Select Please let me know if any other ideas. Thanks again, George "G Lykos" wrote in message ... Thanks, George |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA equiv. of Ctrl-Home w/Freeze Panes?
Give this a try...
With ActiveWindow.Panes(ActiveWindow.Panes.Count) ActiveSheet.Cells(.ScrollRow, .ScrollColumn).Select End With Rick "G Lykos" wrote in message ... Thanks, George |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA equiv. of Ctrl-Home w/Freeze Panes?
Never mind... I grabbed the wrong code from my library... this one just put
the cursor at the split point of the currently scrolled window, not back to the home position. The code you posted is what I have for the going back to the home position. Rick "Rick Rothstein (MVP - VB)" wrote in message ... Give this a try... With ActiveWindow.Panes(ActiveWindow.Panes.Count) ActiveSheet.Cells(.ScrollRow, .ScrollColumn).Select End With Rick "G Lykos" wrote in message ... Thanks, George |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA equiv. of Ctrl-Home w/Freeze Panes?
Thanks nonetheless. The elegance of the structure is giving me something to
think about. "Rick Rothstein (MVP - VB)" wrote in message ... Never mind... I grabbed the wrong code from my library... this one just put the cursor at the split point of the currently scrolled window, not back to the home position. The code you posted is what I have for the going back to the home position. Rick "Rick Rothstein (MVP - VB)" wrote in message ... Give this a try... With ActiveWindow.Panes(ActiveWindow.Panes.Count) ActiveSheet.Cells(.ScrollRow, .ScrollColumn).Select End With Rick "G Lykos" wrote in message ... Thanks, George |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 freeze panes won't freeze top row only | Excel Discussion (Misc queries) | |||
| Ctrl+Home is not A1 | Excel Worksheet Functions | |||
| Programming equiv. of <Ctrl <Home | Excel Programming | |||
| Home or Ctrl-Home | Excel Programming | |||
| Freezed Panes and CTRL+HOME | Excel Programming | |||
Linear Mode
