VBA - enter formulae with quotes

Hi all,

First post . I am pretty new to VBA, know how to edit simple things I record and find on the internet.

I am having trouble editing VBA for a formula that has quotation marks (""). I read I have to put double quotes in, but I keep getting error messages:

eg the formula I would type into the cell is:
="C:\User\fx\"&J3&"\Desktop\"

And I would like to edit the below vba to be entered like the above please:
oEntryWsh.Range("c8").Formula = "=C:\User\fx\" & oEntryWsh.Range("J" & Cell.Row).Value & "\Desktop\"

Thanks very much for reading!

You need to add the quotes in the right places:

oEntryWsh.Range("c8").Formula = "=" & """" & "C:\User\fx\" & oEntryWsh.Range("J" & Cell.Row).Value & "\Desktop\" & """"

That is perfect. Can see where I was going wrong! Thanks for the help Chance2, much appreciated!

That is perfect. Can see where I was going wrong! Thanks for the help Chance2, much appreciated!