Set range only up until blank row in a particular column

Hi All,

"Leith" has been phenomenally helpful in helping me out with the bulk of this report I'm trying to figure out. He's basically re-written my code in order to send an e-mail with a particular range in the body of the email.

There's one more thing I'm trying to figure out and that's how to only select the rows up until the first blank cell in column A.

Below is the code that he provided and I've attached an example spreadsheet. In the spreadsheet I want to send range A1:L24 (because L25 has the first blank cell beginning at A4). All the e-mail code works, I just need help figuring out how to send this particular range. The entries are dynamic, so it won't always be up until row 24...it needs to be only up until the first blank cell in Column A beginning at Row 4:

Please Login or Register  to view this content.

Any help would be greatly appreciated!

Hello seaottr,

This will size the emaqil range based on the entries in column "A".

Please Login or Register  to view this content.

Hello seaottr,

I forgot about the formulas in column "A". The only reliable way is to check each cell's value using a loop. Here is the working code for the CommandButton2.

Please Login or Register  to view this content.

Hello seaotter,

I noticed that also. Unfortunately, I have idea why it isn't showing up. I even tried including a blank row. While this displays the top border for the last entry, the blank row's bottom border is still missing.

Yes, I tried that as well and noticed the same thing

Hopefully someone else can help us figure it out?

If you know how to insert a blank row after the range it sends and include this blank row in the range, it will work (I've tried this manually). Just not sure how to do this?

Originally Posted by Leith Ross

Hello seaotter,

I noticed that also. Unfortunately, I have idea why it isn't showing up. I even tried including a blank row. While this displays the top border for the last entry, the blank row's bottom border is still missing.

Hi seaottr

Try the code in the attached...see if it resolves this issue

The bottom border is missing from the table in the email body (the range that's being sent). How do I get it to show up?