View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Orion[_2_] Orion[_2_] is offline
external usenet poster
 
Posts: 35
Default 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