JackDanIce
Well-known Member
- Joined
- Feb 3, 2010
- Messages
- 9,922
- Office Version
- 365
- Platform
- Windows
Just been reading another posting and prompted a question of my own. When I'm switiching from worksheet to worksheet and then a specific range, I find I have to write the code as:
And so can't understand why this doesn't work:
If another sheet is currently active (say Sheet2)
Can anyone share their opinion on this or suggest a better way (if any) to code this?
Thanks,
Jack
Code:
Worksheets("Sheet1").Select
Range("A1").Select
And so can't understand why this doesn't work:
Code:
Worksheets("Sheet1").Range("A1").Select
If another sheet is currently active (say Sheet2)
Can anyone share their opinion on this or suggest a better way (if any) to code this?
Thanks,
Jack