Set Print area when ending column varies

My print area always starts in E8 and ends on row 40 but the final column varies. The block of data has gaps in it, so using end-right doesn't work. But I do have a variable that determines the end of the block, I just can't figure out how to incorporate it into a formula.

Hello jbrown1968, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following. Thanks.

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.