I have a date in cell on sheet 'macro" which is today's date
When running a macro to attach a sheet and display text in the body the date is not displaying even though I refer to it in my macro
It would be appreciated if someone could amend my code
When running a macro to attach a sheet and display text in the body the date is not displaying even though I refer to it in my macro
Code:
strBody = "Hi Guys" & vbNewLine & vbNewLine & _
"Attached, please find Group Sales as at " & Format(Sheets("Macro").Range("I2"), "dd/mm/yyyy") & vbNewLine & vbNewLine & _
"Regards" & vbNewLine & vbNewLine & _
"Howard"
It would be appreciated if someone could amend my code