hi,
Sub macGoTo()
Sheets("sheet2").Activate
Range("A1").Select
End Sub

But why not just click the tab?????

Regards
FSt1

"jgarner" wrote:

I have a command button (CommandButton1) on 'Sheet1' of an Excel spreadsheet.
I would like to be able to click on the command button and have it take me to
'Sheet2!A1'. What is the code that is entered into the module?