View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Chisholm Bob Chisholm is offline
external usenet poster
 
Posts: 1
Default Selecting a range in a different worksheet

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.