I need to print a area but hide some column each time I print. I get an error message with this. Can someone help me fix this macro?
I want to Hide column K &L, and then unhide after I print.
![]()
Sub print_route() .Columns("K:L").EntireColumn.Hidden = True ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True .Columns("K:L").EntireColumn.Hidden = False End Sub
Bookmarks