Hi im trying to have an if formula in the vba code but its breaking due to the text having a quotation mark.
im trying to do this, I have tried double quotation marks but to no avail. also tried adding & Chr(34) but the text doesnt say that so it wont run.
im trying to do this, I have tried double quotation marks but to no avail. also tried adding & Chr(34) but the text doesnt say that so it wont run.
VBA Code:
If Range("C8") = ""4" pipe"" Then
the red " is the issueIf Range("C8") = ""4" pipe"" Then