Serious problem with "Select"

  • Thread starter Thread starter artmajster
  • Start date Start date
A

artmajster

I have something like that in Sheet1:

Sub first()
Worksheets("Sheet2").Activate
Range("A2").Select

End Sub

and it does'n work :( why ?? Could you me how can I fix it ?
 
You cannot select anything in Sheet2 from code in Sheet1. If you pu
the code in a module (Insert | Module), it will work.
 
Try

Sub first()

Worksheets("Sheet2").Activate
ActiveSheet.Range("A2").Select

End Su
 
You must log in or register to reply here.

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

Excel VBA help: Text file formatting 19
Object variable or with Block variable not set 9
Run two macros for two different sheets 11
Conflict 8
Problem using Range objects 1
Junp start my Select Case Macro 12
Copy filtered data to sheet 2 1
My Never ending ARRAY code problems 18

Back
Top