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

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