Copying Cells with format from Excel to Outlook

Hi Everyone!

I'm new to excel-outlook programming so please, bear with me. Basically, my problem is, I'm trying to work on a macro that when used, performs a set of calculations on the excel file and then copies the result to the body of my message. I read through Ron De Bruin's site where he provided an amazing amount of help (Thanks! ). I've managed to get the calculations part done and the problem is that, whenever all the other calculations are performed and it's now time to copy the result to outlook, the conditional formatting doesn't get copied as well. I used Ron's code as a reference and his involves .PasteSpecial, however, I tried to implement it, and still got no luck. Any Ideas? Below is the sample code I based from and is the part where I know the formatting gets lost:

Please Login or Register  to view this content.

Justin,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.