Excel 2013 64bit VBA syntax error "Compile error: "Expected: End of Statement"

Question

I have the following code, which gives me the Compile error: "Expected: End of Statement" in the Subject line of code after the "Inc" Range.

This code is part of a module which opens MS Outlook email and enters data from specific cells in the data sheet (generated from a Userform) in to the Subject field of the email.

The code:

'This bit tells it where to send the email to, what the subject line is etc
    .to = "[email protected]"
    .CC = "[email protected]"
    .BCC = ""
    .Subject = "Inc" Range("H6").Value & " " & Range("G12").Value & " - " & Range("G14").Value & " " & Range("H8").Value
    .HTMLBody = RangetoHTML(rng)
    .Display

   End With
   On Error GoTo 0

Is this sufficient information?

Jack Morton · Accepted Answer · 2016-05-30 13:11:08Z

2

Can you check if it's because is missing the "&" operator

.Subject = "Inc"  Range("H6").Value & " " & Range("G12").Value & " - " & Range("G14").Value & " " & Range("H8").Value

Should be

.Subject = "Inc" & Range("H6").Value & " " & Range("G12").Value & " - " & Range("G14").Value & " " & Range("H8").Value

edited May 30, 2016 at 13:11

answered May 30, 2016 at 12:02

Jack Morton

1547 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Vincent G Over a year ago

On Error Goto 0 reset the error handler to its default, why do you think it isn't good practice?

Jack Morton Over a year ago

Corrected my previous message, I read some documentation and you are right (here analystcave.com/vba-proper-vba-error-handling) about is the only way to reset the error handler. Thanks for correcting me. @VincentG

TheShyButterfly Over a year ago

Thank you (apologies for the delay in response.

Collectives™ on Stack Overflow

Excel 2013 64bit VBA syntax error "Compile error: "Expected: End of Statement"

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related