Freezed Panes and CTRL+HOME
Hi TWIMC,
On a workbook, if you have Frozen Panes and then you press CTRL+ HOME, the selected cell becomes the cell directly below where the intersection of the frozen panes. So the question is there a way to perform a CTRL+HOME in VBA code without using the dreaded Sendkeys? TIA KM |
Freezed Panes and CTRL+HOME
there may be other ways but this works:
Sub Homing() With ActiveWindow.ActivePane .ScrollRow = 1 .ScrollColumn = 1 .VisibleRange(1).Activate End With End Sub -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Kevin McCartney wrote : Hi TWIMC, On a workbook, if you have Frozen Panes and then you press CTRL+ HOME, the selected cell becomes the cell directly below where the intersection of the frozen panes. So the question is there a way to perform a CTRL+HOME in VBA code without using the dreaded Sendkeys? TIA KM |
All times are GMT +1. The time now is 02:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com