VBA to copy, highlight cells then e-mail.

Hi,

I have got the following code that automatically copies a range of cells within the sheet i am on and then creates a new excel workbook then sends it to an e-mail address specified.

Is there anyway i can change it so that it copies the specified range (A1:K50) but then when it pastes that range into another sheet i would like it to highlight some of the cells yellow based on what i had higlighted on the sheet when i run the vba

e.g.
i hightlight B6:E10 then run the VBA, i want it to copy A1:K50 into another sheet (as below) but then on the new sheet highlight cells B6:E10.

Please Login or Register  to view this content.

Regards,
Jamie