Select method of Range class failed - but why???

[Orion]

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

 

[paul.robinson]

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

 

[JE McGimpsey]

not really - you can select sheets as well.

 

[JE McGimpsey]

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

 

[Orion]

I couldn't get it to work other than using a "normal" command button
instead of an AciveX button.
I tried all your suggestions including those of Paul.

Anyway, at least I got the hint, that the AciveX button could be the
reason for my problem.

I'm actually working with Excel 2000 on a Win2000 OS.

Thanks to all of you

Norbert