VBA code for new line using OLAppointment.Body

[mecerrato]

I am using this piece of code in a macro that creates an appointment.
Is there a way to add a carriage return in this code, I cannot figure out the syntax for a new line (carriage return). I would like to place it after the first range value.

OLAppointment.Body = Worksheets("Loans").Range("I" & ActiveCell.Row).Value & " County, HTH Loan Limit " & Worksheets("Loans").Range("R" & ActiveCell.Row).Value & " " & Worksheets("Loans").Range("K" & ActiveCell.Row).Value

any help would be greatly appreciated

 

[mecerrato]

I am using this piece of code in a macro that creates an appointment.
Is there a way to add a carriage return in this code, I cannot figure out the syntax for a new line (carriage return). I would like to place it after the first range value.

OLAppointment.Body = Worksheets("Loans").Range("I" & ActiveCell.Row).Value & " County, HTH Loan Limit " & Worksheets("Loans").Range("R" & ActiveCell.Row).Value & " " & Worksheets("Loans").Range("K" & ActiveCell.Row).Value

any help would be greatly appreciated

Sorry, I was able to find something as simple as VbNewline and it worked perfectly.