runtime error 13 type mismatch

  • For CDO code. Can someone please explain why I am getting this error with the following part of the code highlighted:


    Code
    StrBody = "PLEASE DO NOT REPLY TO THIS EMAIL" & vbNewLine & vbNewLine & _
                  "Please see bellow estimated total cargo for the DUKC MSD" & vbNewLine & vbNewLine & _
                  "DUKC MSD    " & ThisWorkbook.Sheets("Drafts").Range("U81") & vbNewLine & _
                  "Equivalent total metric tonnes  " & ThisWorkbook.Sheets("Drafts").Range("T13") & vbNewLine & vbNewLine & _
                  "Regards" & vbNewLine & _
                  "Draught Surveyor" & vbNewLine & _
                  ThisWorkbook.Sheets("Report").Range("G60") & vbNewLine & _
                  ThisWorkbook.Sheets("Advice").Range("B5") & vbNewLine & _
                  ThisWorkbook.Sheets("Advice").Range("B6")


    Tks in advance.

  • Re: runtime error 13 type mismatch


    Hi S O. Thanks for your reply. I have just realised cell T13 had a N/A value which was causing the problem. All fixed now.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!