Hide sheet from macro

[nigelog]

I need to open a hidden sheet (sheet 2) in order to copy to it. The code I have opens all hidden sheets. How would I ammend this to close sheet 2 after the copy/paste, and not close all sheets. Many Thanks

Please Login or Register  to view this content.

[ulfah]

I am assuming that you have a range copied, and that you wan to paste this selection into sheet 2, then hide sheet 2. If this is the case you could try the following:

Please Login or Register  to view this content.

Hope it helps
Ulfah