help with date not showing correctly

[288enzo]

H6 is formatted as Range("H6").NumberFormat = "dddd, mmmm d".

I'm using the following to populate the body of an email.

begins = "Our first session begins - <b style=""font-family:Courier New; font-size: 15px; color:#c00000""> " & Range("H6") & "<br><br>"

The problem I'm having is, instead of dddd, mmmm d showing in the email, I'm getting mm/dd/yyyy.

What would you suggest?

Thank you

 

[6StringJazzer]

In VBA, Range("H6") will give you the underlying value of the cell, regardless of how it is formatted for display. Here is the easiest option:

begins = "Our first session begins - <b style=""font-family:Courier New; font-size: 15px; color:#c00000""> " & Range("H6").DisplayFormat & "<br><br>"

 

[288enzo]

In VBA, Range("H6") will give you the underlying value of the cell, regardless of how it is formatted for display. Here is the easiest option:

begins = "Our first session begins - <b style=""font-family:Courier New; font-size: 15px; color:#c00000""> " & Range("H6").DisplayFormat & "<br><br>"

Thank you, but doing so I go a run-time error 438. Object doesn't support this property or method.

 

[6StringJazzer]

Sorry, try this one

begins = "Our first session begins - <b style=""font-family:Courier New; font-size: 15px; color:#c00000""> " & Range("H6").Text & "<br><br>"

 

[288enzo]

Sorry, try this one

begins = "Our first session begins - <b style=""font-family:Courier New; font-size: 15px; color:#c00000""> " & Range("H6").Text & "<br><br>"

That was the trick! Thank you very much.

 

[6StringJazzer]

You're welcome! Sorry for the misfire.