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