VBA Code to force cell value into time format

[Malcolm torishi]

Hello
can any help please, I have a VBA Code that sends an email automatically from a spread sheet. With the code there is a section that allows me to write some word that will appear with the email. Also attached to the wording is “& range (AA6 ) “that takes a formatted time (10:18) and inserts it int the body of the email being sent. But because the cell on the spreadsheet AA6 is formatted to time, when it appears on the email it’s just numbers (0.67546) for example. Is it possible to force the value in the email to time format eg 10:18 rather than 0.67546
thank you

 

[JoeMo]

Instead of using Range("AA6") which defaults to the value property of the range, try using Range("AA6").Text

 

[Malcolm torishi]

Thank you I will give it a go tomorrow

 

[JoeMo]

Thank you I will give it a go tomorrow

You are welcome - thanks for the reply.