print area defined

really any excel, any information, with the cells being filled from A1 through L ?.

In a previous process, I defined the print area for the first report that was produced.

Now I am adding different information and need to be able to redefine the print area. I have automated all of the other steps except redefining the print area. That one sure is tricky.

The coding above sure is close.

I appreciate your help!

I tried this, thinking the last part needed linking, but it didn't work:

Dim lastrow As Long

lastrow = ActiveSheet.Cells(Rows.Count, "A").End(xlDown).Row

ActiveSheet.PageSetup.PrintArea = ("$A$1:$H$" & lastrow)