How do I select Worksheet from another worksheet (Excel VBA)?

  • Thread starter Error code when select worksheet
  • Start date
E

Error code when select worksheet

From Sheet2 I use macro command:

Sheets("Start").Select
Cells.Select

it work fine, but when I try to put this code in button from Sheet2
and when ckicked i got an error message:

Run-time error '1004'
Select method of range class failed.

pls can someone help me?
Thanks
 
N

Nick Hodge

Try Activating the sheet

Sheets("Start").Activate
Activesheet,Cells.Select

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk




"Error code when select worksheet"
 

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

Why this code is not work? 4
Excel VBA - Problem with Closing Print Preview 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Run-time error '1004' 2
How to activate Sheet2? 5
Excel help with Macro code in excel 1
Excel VB 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Top