button to return to top of spreadsheet
 

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

button to return to top of spreadsheet
 

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

--
Don Guillett
SalesAid Software

"Cindy B" wrote in message
...
Is there a way to create a macro/button that will return me to the top of
the
spreadsheet?
thanks in advance
--
Cindy B

button to return to top of spreadsheet
 

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

On Mon, 7 Mar 2005 15:53:04 -0800, "Cindy B" wrote:

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

button to return to top of spreadsheet
 

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

"Cindy B" wrote:

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

button to return to top of spreadsheet
 

glad to help

--
Don Guillett
SalesAid Software

"Cindy B" wrote in message
...
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

"Cindy B" wrote:

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