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

[g1987]

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]

Possibly using the Union method...?

[Mordred]

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]

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

[g1987]

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?

[Mordred]

No worries, the dup post has been taken care of.