asked on
With ActiveWorkbook.Sheets("Filtered List")
LR = .Range("B" & Rows.count).End(xlUp).Row
Set FindRow = .Range("B:B").Find(What:="Product Information", LookIn:=xlValues)
findrownumber = FindRow.Row
Application.PrintCommunication = False
With Sheets("Filtered List").PageSetup
.PrintArea = "A1:G" & LR
.FitToPagesWide = 1
.FitToPagesTall = False
.PrintTitleRows = findrownumber