Hello, all,

I know there must be a way to do this, so I'm throwing it out to you.

I am trying to redefine a print area. It is different for every sheet. What I do know is that it will end in column L.

Can I do something similar to this? (This, of course, failed.) ActiveSheet.PageSetup.PrintArea = "$A$1:L1.End(xlDown).Select"

ActiveSheet.PageSetup.PrintArea = "$A$1:$L$147" That works and I am trying to make the end property a variable.

Any ideas?