Help! Calling hidden sheets?
 

Hi

You can't activate ranges on hidden sheets like you can't activate them
manually, without unhiding them, too.
But you can refer to cells on hidden sheets, like
x=Worksheets("abc").Range("A2").Value


--
(Don't use my reply address - it's spam-trap)

Arvi Laanemets


"Gary" wrote in message
...
I have several modules that call on sheets to perform calculations.
Everything works fine, but when I hide the sheets, the program crashes as it
cannot find the sheet to be called. Is there any way to call 'hidden
sheets?

Syntax used to call worksheets a
1. Worksheets("abc").Activate
2. Sheets("abc").Select

Thanks to all.