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

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