quote marks in vba

[cw]

Hi all

I am just having a bit of trouble adding a find and replace to my vba

long story short

I want to find and replace the word qoutemark with a "

how can I add this " to vba without it throwing up an error or changing """
to """"

thanks
Craig

 

[Tony Jollans]

I'm not entirely sure what you're having a problem with, but ...

... quote marks (") are special characters in VBA, used for delimiting
strings. When you want to put one inside a string, special techniques are
needed, the easiest of which is just to double up the character, so """"
results a string containing a just one quote character. An alternative is to
use the Chr function - Chr(34) is a quote character.

 

[cw]

cheers

I have found the problems, I am off to put my head down the toilet. it was a
spelling error on the line above

sorry to waste every ones time

craig