Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The code for a command button on SheetA says:
Worksheets("SheetB").Activate Range("B2").Select The "TakeFocusOnClick" property of the command button is set to false. When the button on SheetA is clicked, the active worksheet switches OK to SheetB, but the Range("B2").Select statement generates an error '1004': "Select method of Range class failed" Does the code for selecting on SheetB need to be in a separate location than the code for SheetA's command button, such as in a Worksheet.Activate event? Or what else have I overlooked, left out, or done wrong? Thanks for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Please help with selecting a range | Excel Discussion (Misc queries) | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
Selecting a Worksheet Range | Excel Worksheet Functions | |||
selecting a range in vb | Excel Programming | |||
Help with selecting a range... | Excel Programming |