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

  • Thread starter Thread starter Error code when select worksheet
  • Start date 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
 
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"
 
Back
Top