button to return to top of spreadsheet

[Guest]

Is there a way to create a macro/button that will return me to the top of the
spreadsheet?
thanks in advance

 

[Don Guillett]

a couple of ways

Sub CtrlHome()
SendKeys "^{home}"
End Sub

Sub gghome() 'Tom Ogilvy
rw = ActiveWindow.SplitRow + 1
col = ActiveWindow.SplitColumn + 1
Cells(rw, col).Select

End Sub

 

[Gord Dibben]

Cindy

Sub Top()
Range("A1").Select
End Sub

Assign to a button.

OR just hit CTRL + Home to go to top without using a macro or a button.


Gord Dibben Excel MVP

 

[Guest]

Thanks Don and Gord -
Didn't know the Ctrl+Home worked - so will see if that will do it for them -
if not - thanks for the code - I'll file that in case they really need the
buttons...
thanks again - it is so great to get help on these forums!!!
Your Awesome!
Cindy