Macro - Mail every worksheet using A1 as address

[sknight22]

Hello


I am using the below code to send multiple sheets to email addresses in cell a1. The problem I have is that one column on the sheet is formatted as time but when the macro is run it changes the time to the wrong format (see below for example - original time in blue & what the macro changes it to in red) when stepping through the code I can see the change happens when it gets to ".Cells.PasteSpecial xlPasteValues"


can anyone help me? im stuck


LOADING TIME
13:00:00
15:00:00
16:00:00




LOADING TIME
0.541666667
0.625
0.666666667

**only problem is the site wont let me post my code?

[Kenneth Hobs]

Welcome! I have not heard of no code being allowed. URL's are not allowed until you have 5 posts.

Post code between code tags. Click the # icon to insert the tags.

Just do a paste to keep the format?

Most use htmlBody in Outlook object to convert a range to html. Ron de Bruin has some examples on his site.

[sknight22]

Hello

Thanks, yes it does say URLs, my apologies but I cant see any urls in my code so im confused.

The code im using is from Ron de Bruin site

[Norie]

Kenneth

You can find the code over here (https://www.mrexcel.com/forum/excel-questions/1055625-mail-every-worksheet-using-a1-address.html).

[sknight22]

sorry - didnt realise I was doing something wrong