HELP! Runtime error 13 Sending two non-contiguous rows as a table

**g1987** · 03-14-2012, 08:46 PM

Hi,

I have the code below and I'm trying to send two non-contiguous rows in an email to make it look like a table. I have this line of code below that's causing the error.

Please Login or Register  to view this content.

How else would I do this?? Please help. The entire code is below

Please Login or Register  to view this content.

the RangetoHTML function is below also

Please Login or Register  to view this content.

**dangelor** · 03-15-2012, 05:08 PM

Possibly using the Union method...?

**Mordred** · 03-15-2012, 05:08 PM

Hi g1987, I don't know if this is the issue but your line:

Please Login or Register  to view this content.

does not explicitly call the cells on Sheets("Jan. 2012"). try

Please Login or Register  to view this content.

If you have a lot of lines that are being declared from sheet("Jan. 2012") then you may be better off explicitly declaring the worksheet as WsJan like in the following:

Please Login or Register  to view this content.

**Mordred** · 03-15-2012, 05:10 PM

Why would you post the same question twice? All this does is clutter the forum. Thread will be closed.

**g1987** · 03-15-2012, 05:26 PM

Hi Mordred,

I tried what you suggested and it doesn't work.

As for the duplicate post, I thought I was successful in deleting it. How can I remove the old post?