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?