Hi All,

5 minutes ago, the following code gave a print preview of any area I selected on the worksheet but now I get a compile error.

I'm pretty sure I didn't alter it but I have been working on other macros so does anyone have any ideas?

Sub Print_Preview()
'
'Preview of the print area
With Worksheets("MASTER")
    .PageSetup.Orientation = xlLandscape
    .PageSetup.PaperSize = xlPaperA3
    End With
    Selection.PrintPreview
End Sub