Macro dependent on hidden sheet?
Yeah Oddly enough I tried it again after changing some ".Select" commands to
".activate" and it's working perfectly now!!!
Thanks for replying tho!
"Bob Phillips" wrote:
I can read data from a hidden sheet, so it must be something else.
Show us the full code.
--
HTH
RP
"Cee_Pritchard" wrote in message
...
I've written a Macro which returns information held in a sheet I now want
to
hide (I dont want anyone messing about with the data!)
But when I hide the sheet the macro can no longer find the information and
says there is a runtime error!
Any ideas how I can get it to look up the information from this hidden
sheet?
Cheers
|