Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
hidden sheets | Excel Discussion (Misc queries) | |||
Calling cell values from random sheets from a base sheet | Excel Worksheet Functions | |||
How do i reveal hidden sheets | Excel Discussion (Misc queries) | |||
Hidden Sheets | Excel Worksheet Functions | |||
Operating on hidden sheets | Excel Discussion (Misc queries) |