In article ,
says...
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?

Don't know if this will help, but what happens if you turn on the macro
recorder (Tools | Macro Record new macro...) and use the UI to carry
out a CTRL HOME?

Remember to turn off the recorder.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions