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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visual Basics Error - Goto 1
Multi-Selection with Hand-writing draw tool 0
Code corrupts file (XL2003) 3
Excel VB to create and send an outlook appointment with html code 1
Too much data for this code? 4
Code problem 16
Problem with searching through content and delete unwnated column 0
Command Button to import worksheets 2

Top