Here's the code I have for each column. This is for column H, Routing --
![]()
Sub Print_Routing() ' Dim PrintArr As Variant PrintArr = Array("H") For i = 0 To UBound(PrintArr) Rows("1:2").Select Selection.EntireRow.Hidden = True Columns("H:H").Select Selection.AutoFilter Field:=8, Criteria1:="<>" Columns("D:EV").Hidden = True Columns(PrintArr(i)).Hidden = False ActiveSheet.PrintPreview Next i Columns("D:EV").Hidden = False Selection.EntireRow.Hidden = False Selection.AutoFilter Field:=10 End Sub
Bookmarks