Go Home

So how can you programmatically press "Ctrl + Home? You can't do it directly but here's a possible solution.

SplitRow and Splitcolumn report where the rows and columns are split. If there is no split they return zero. This means we have to add "1" to each value so we go where we want to.

''***************************************************************************
'' Purpose : Acts as if you've pressed Ctrl + Home
'' Written : 05-Aug-2004 by Andy Wiggins, Byg Software Limited
''
Sub ScrollToHomeCell()
	ActiveSheet.Cells(ActiveWindow.SplitRow + 1, ActiveWindow.SplitColumn + 1).Select
End Sub

Published: 05-Aug-2004
Last edited: 05-Jun-2005 19:28