How to Insert last use Column in a Range

[johndrew]

I ran a macro which found the last use Column. Which was 10
I want a Print Range from "E2" to "E" Last Column which was 10. The name was LastCol

How do I write that VBA range E2:E10

 

[Smitty]

Do you mean the last used row?

You can record a macro setting the print area, then substitute your variable in the string.

ActiveSheet.PageSetup.PrintArea = "$E$1:$E$" & lr

Can you post the code that you've got now and explain if you want to look at both rows and columns being dynamic, or just one or the other?