sknight22
05-17-2018, 07:30 AM
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?
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?