View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tushar Mehta Tushar Mehta is offline
external usenet poster
 
Posts: 126
Default Refer to a hidden sheet using a macro.

In article ,
says...
I have written a macro that will move data into a sheet that is hidden.
However, when I run it I get the debugger message telling me it has failed.
If I unhide the sheet and run it then it works fine.

What is the best way round this?

Thanks in advance.

What is the code that moves the data? My guess is you are activating or
selecting something on the hidden sheet.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005