Help! Calling hidden sheets?
 

Hi Gary

If you want to select it you must unhide it.
But for most things you don't have to select the sheet

example to copy to the hidden sheet

Selection.Copy Sheets("abc").Range("a1")


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"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.