I am trying to record a
Macro to print selected cells then return the worksheet to its original format. I am hiding columns B through H, printing
A7:I68. While recording the Macro the print comes out correct. Once saved it only prints column A7:A68, does not include column I.
ActiveSheet.Unprotect Columns("B:H").Select Selection.EntireColumn.Hidden = True Range("A7:I68").Select ActiveSheet.PageSetup.PrintArea = "$A$7:$I$68" Selection.PrintOut Copies:=1, Collate:=True Columns("A:I").Select Selection.EntireColumn.Hidden = False ActiveWindow.SmallScroll Down:=-72 Range("A10").Select ActiveSheet.Protect DrawingObjects:=False, Contents:=True, Scenarios:= _ False