Hello All,
I am trying to print area where if cells D5:LC5 are active (have text in them) it would print area A1 to ?52, so if I have writing in cell H5 it would print A1 to H52, I think I am getting close plase help,Jeff
Here in my current print code
Thank you for any and all help, JeffPrivate Sub Workbook_BeforePrint(Cancel As Boolean)
With Sheets("Sheet1")
.PageSetup.PrintArea = "$A$1:$LC$52" & _
.Range("D5:LC5").Find("*", .Range("A1:LC52"), xlValues, xlWhole, xlByRows, xlPrevious).Row
End With
End Sub
Bookmarks