View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
witek witek is offline
external usenet poster
 
Posts: 147
Default Runtime error 1004: Select method of worksheet class failed

chuckm wrote:


Sheets("Config").Select ====== it bombs here. Config definitely exists.


but is probably hidden or protected and can't be selected so .select fails.
Claus already gave you solution.
Do not select anything if it does not have to be selected.