VBA Print dynamic range

[Steven Cohen]

Hi All

I am struggling to find code for this, I have looked through the forums but haven't found one that works for me.

All I want to do is have a print function on a report tab that varies in length depending on the results given. Columns will always be from $E2:$U - depending on the results given this can be anywhere from U20 all the way on to U1000 etc.

Column U does not always have a value in it, all columns E-T will always have a value in them to find the last row.

Any help will be greatly appreciated

Thanks

 

[gallen]

That will get you the last used row so you can select the full range and print out

Dim lLastRow as long

    lLastRow = Range("E" & Rows.Count).End(xlUp).row

So you can print out by

Range("[COLOR=#333333][FONT=Verdana]$E2:$U" & lLastRow).PrintOut[/FONT][/COLOR]

 

[Steven Cohen]

So simple, so elegant! Thank you so very much! It works perfectly

 

[gallen]

No problem. Determining the last used row is something you'll use a lot.