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

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

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

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

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

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

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

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?