Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Tom,
Thanks... Your suggestion has me about 95%+ there but... As written, this does in fact take me to the top/left of the "unfrozen" window but, unlike the <Ctrl<Home keystroke combo does not take into acount hidden columns (e.g. top/left of unfrozen area is D11 but macro has columns D thru G hidden; <Ctrl<Home goes to H11 but code goes to D11) Any thoughts? -Carl "Tom Ogilvy" wrote: Sub CtrlHome() Application.Goto Range("A1"), True ActiveWindow.VisibleRange(1, 1).Select End Sub -- Regards, Tom Ogilvy "cawatson" wrote in message ... On a sheet, executing <Ctrl <Home moves the cursor to the top/left corner of the "unfrozen" window (not just the displayed window) regardless of horiz/vert scroll positions. Anyone know how to code the same movement? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HOW TO FORMAT THE HOME KEY WITHOUT USING CTRL | Excel Discussion (Misc queries) | |||
Ctrl/Home changes the Zoom | Excel Discussion (Misc queries) | |||
Ctrl+Home is not A1 | Excel Worksheet Functions | |||
Home or Ctrl-Home | Excel Programming | |||
Freezed Panes and CTRL+HOME | Excel Programming |