Can a macro format a hidden sheet?
 

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.

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


"Robert" wrote:

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.