Can a macro format a hidden sheet?

R

Robert

I have an open sheet, which is only open to record the macro. Then I hide
the sheet and use the keyboard shortcut to clear the hidden sheet. This
won't work. I get an error in the Sheets("report").select area. Guessing
because it can't select a sheet that it doesn't see. If I unhide the sheet,
the macro works fine. How can I make this work and still have the sheet
hidden?

Also, what's the difference between hidden and very hidden? Thanks.
 
G

Gary Brown

Robert,
Refer to the hidden sheet by it's name, such as 'Sheet1'.
For example:
Sheets("Sheet1").Range("A1:A16").ClearContents

Hidden sheets can be seen from the FORMAT / SHEET / HIDE[UNHIDE] form.
Very Hidden sheets can only be seen in the Visual Basic Editor.
HTH,
Gary Brown
 
Top