MR Campbell
Board Regular
- Joined
- Aug 2, 2002
- Messages
- 113
I have a routine where i wish to select a cell in a non-active sheet - when I mean select, I simply mean to place the "cursor" at this cell.
E.g. If SheetA is the active sheet and I want to place the cursor in cell "B2" on SheetB, the code below does not work :
Sheets("SheetB").Range("B2").Select
At the moment it generates an error message.
E.g. If SheetA is the active sheet and I want to place the cursor in cell "B2" on SheetB, the code below does not work :
Sheets("SheetB").Range("B2").Select
At the moment it generates an error message.