View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Young-Hwan Choi Young-Hwan Choi is offline
external usenet poster
 
Posts: 17
Default 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....