what's wrong?

I trigger a commandbutton from the VB-toolbar, with following code and
get an error message at the 3rd line:
Select method of Range class failed

code:

Application.ScreenUpdating = False
Sheets("patterns").Select
Range("C7").Select


Any clues?

Thanks,
Norbert

Hi
Use Sheets("patterns").Activate
You select ranges and activate sheets.
regards
Paul

not really - you can select sheets as well.


In article .com,
wrote:

i
Use Sheets("patterns").Activate
You select ranges and activate sheets.
regards
Paul

Are you running XL97 and using an ActiveX button? If so, make sure the
button's Take Focus on Click property is set to False.

You could also use

Application.ScreenUpdating = False
Application.GoTo Sheets("patterns").Range("C7") Scroll:=True


In article ,
Orion wrote:

what's wrong?

I trigger a commandbutton from the VB-toolbar, with following code and
get an error message at the 3rd line:
Select method of Range class failed

code:

Application.ScreenUpdating = False
Sheets("patterns").Select
Range("C7").Select


Any clues?