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.