How To PrintArea Until Last Row With Data?

[aedctalk]

Hi,

I'm trying to PrintArea until last row of data.

Range("B4:AE94").PrintOut

However. We add and delete rows constantly and i dont want to have to always go in VBA and update the AE94 #

Would the below work?

Range("B4:AE" & lastrow).PrintOut or somethign like that?

The other issue i'm having is between B4:AE94 i have spaces or empty rows within the the entire Range.. Its only one skipped row here and there.. would the solution be to make it look for the first instance of 3 empty rows?

Thanks for any help!

 

[bensonsearch]

there is rowcount, can assign to a variable. it counts the number of continuos rows with data (assuming no blank rows)