VBA IF Formula with the text having quotation marks

[B-Man]

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.

If Range("C8") = ""4" pipe"" Then

If Range("C8") = ""4" pipe"" Then

the red " is the issue

 

[Fluff]

Try it like

   If Range("C8") = "4"" pipe" Then

 

[B-Man]

NM i just tried adding heaps of quotation marks.... figure out that if i doubled the one in the code it worked...

If Range("C8") = "4"" pipe" Then

something so simple had me stuck for over half an hour

 

[Fluff]

Glad to help & thanks for the feedback.