Please could you check this line of code

[ipbr21054]

Morning,
I am stuck with the correct way of adding the cell for my PDF to be generated.

I have two options in my code.

This which works fine.

MsgBox "GENERATED PDF " & Range("G13").Value & vbNewLine & vbNewLine & " WAS NOT SAVED AS IT ALLREADY EXISTS", vbCritical + vbOKOnly, "GENERATE PDF FILE MESSAGE"

But trying to get the cell G13 to work in this line if causing me an issue for some reason.

This works if i dont apply G13

pdf = MsgBox("GENERATED PDF " & " WAS SAVED SUCCESSFULLY" & vbNewLine & vbNewLine & "DO YOU WISH TO NOW PRINT IT ?", vbExclamation + vbYesNo, "GENERATE PDF FILE MESSAGE")

But my attempt keeps telling me required list separator or )

pdf = MsgBox("GENERATED PDF " & Range("G13").Value " & " WAS SAVED SUCCESSFULLY" & vbNewLine & vbNewLine & "DO YOU WISH TO NOW PRINT IT ?", vbExclamation + vbYesNo, "GENERATE PDF FILE MESSAGE")

 

[mole999]

pdf = MsgBox("GENERATED PDF " & Range("G13").Value " & " WAS SAVED SUCCESSFULLY" & vbNewLine & vbNewLine & "DO YOU WISH TO NOW PRINT IT ?", vbExclamation + vbYesNo, "GENERATE PDF FILE MESSAGE")

delete the speech mark I have made bold, red underlined and try it

 

[ipbr21054]

Many thanks just worked fine.

I get confused when it sai put ) but didnt noticed that something had to be added etc

 

[mole999]

Many thanks just worked fine.

I get confused when it sai put ) but didnt noticed that something had to be added etc

we all do