View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
geebee geebee is offline
external usenet poster
 
Posts: 190
Default runtime error 1004

hi,

i have the following code behind a button in sheet1:
sheets("pivot").select
range("F2").select

but when i click the button in get the following message:
runtime error 1004: select method of range clas failed.

i did a small test to place the code and button in the same worksheet as the
range (pivot sheet), and it worked just fine.