Freezed Panes and CTRL+HOME

[Guest]

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

 

[keepITcool]

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 :