Tools - Marcros - Macro
Name your macro.
Create
On the code sheet:
Sub your macro name()
'This will go to the top of sheet1
'To go to the bottom change the Range("X") to a
'cell you want to go to. If you only want it
'to work on the active sheet, you can remove
'the sheet line!
Sheets("Sheet1").Select
Range("A1").Select
End Sub
On the macro menu, Option lets you assign a hot key to the VB Macro. Like CTRL-t for Top.
To make a button;
View - Forms
Select The button and place and size on your sheet where you want it. Select your macro name from the list, Edit the macro Button face lable and your done. (Click on the default button lable and delete & re-type.)
Hope this is what you wanted? JSW
Hi matthew try this code.
The other code that joe Was helped you with selects the sheet then the cell, it runs slower and I found that didn't work how I wanted it to.I then recieved help on this site to get the following code.
steve w
Private Sub CommandButton1_Click()
Application.Goto _
Reference:=Sheet4.Range("A71"), Scroll:=True
End Sub