How to print a named range that is within a hidden sheet?

[PATSYS]

Hi all,

I have a named range called "PrintRange" lying in sheet3.

Now sheet 3 is hidden, properties is set at 2 - XLSHEETVERYHIDDEN.

I tried to run the code

Sheets("Sheet3").Range("PrintRange").PrintOut

But nothing is happening.

What is wrong with it?

Thanks

 

[Trebor76]

Hi PATSYS,

Excel needs to "see" the tab to print it. The following work around will do the job:

Sub Macro1()

    Application.ScreenUpdating = False

    With Sheets("Sheet3")
        .Visible = -1 'Visible
        .Range("PrintRange").PrintOut
        .Visible = 2 'Very Hidden
    End With
    
    Application.ScreenUpdating = True

End Sub

HTH

Robert

 

[PATSYS]

Thanks Robert.