Macro not displaying date wnen displaying on body of email

[howard]

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

 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

 

[howard]

My Apologies Range("I2") should have been Range("I1")

I only picked tis up now when retesting and code now working