Visual Basics - Problem with code

S

Shirl

I have created a code in Excel which on clicking on a button, takes you to
another worksheet then to a selection of cells which I have named. It will
take me to the worksheet but comes up with an error. Please let me know
whats wrong with the following:

Private Sub CommandButton2_Click()
Application.Goto ActiveWorkbook.Sheets("WGTN & KAPITI").Activate
ActiveSheet.Range("Shailesh").Activate
End Sub
 
Top