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
 
Top