Cannot address a hidden sheet in my macro

[Guest]

I`m building a macro in which I refer to a hidden sheet. If the sheet is unhidden everything works fine but if I hide the sheet I get an error! Has anyone ever stumbled accross this problem and does anyone know a solution?

thnks!

Remi,
Holland.

 

[NateO]

You could unhide the sheet early in your procedure:

Sheets("Sheet1").Visible = True

Then hide the sheet at the end

Sheets("Sheet1").Visible = False


Cheers, Nate

 

[Guest]

So I can set the sheet to hidden as default and hide and unhide it in my macro?

Gonne try right away!

Cheers!

 

[Guest]

Yes it works...
GREAT