| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SaveAs method error | Excel Discussion (Misc queries) | |||
| Paste method error in macro | Excel Discussion (Misc queries) | |||
| PasteSpecial Method Error | Excel Discussion (Misc queries) | |||
| Activate method of Worksheet class fails in Excel 2000 | Excel Discussion (Misc queries) | |||
| Unprotect method run-time error | Excel Programming | |||
Threaded Mode
