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!
Bookmarks