I am trying to set up a page break based on the last piece of information on the sheet.
This piece of code works so far. But I am trying to get the upper range to be something like 3 rows higher than the last row.
I tried![]()
LastRow = Range("A65536").End(xlUp).Row ActiveSheet.PageSetup.PrintArea = "A1:F" & LastRow
but it comes up with a Syntax error.![]()
ActiveSheet.PageSetup.PrintArea = "A" & LastRow-3 & ":F" & LastRow
Bookmarks