You need to add the quotes in the right places:
oEntryWsh.Range("c8").Formula = "=" & """" & "C:\User\fx\" & oEntryWsh.Range("J" & Cell.Row).Value & "\Desktop\" & """"
You need to add the quotes in the right places:
oEntryWsh.Range("c8").Formula = "=" & """" & "C:\User\fx\" & oEntryWsh.Range("J" & Cell.Row).Value & "\Desktop\" & """"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks