why error for activate method
Current activesheet is sheets(1).
Sheets(2).Range("A1").Activate
The code above gives an error saying that
Run time error:1004
Activate method of range class failed.
The "activate" method works fine when I am in the same worksheet.
Say, when I am in sheets(2) and use Sheets(2).Range("A1").Activate, then it
works.
(None of the sheets is chartsheet.)
Is it normal? I thought it worked fine....
|