quotes in formulas using vba
 

I want to enter the following formula into cell a5

=SUBSTITUTE(F3," ","")

I tried this:

range("a5").value= "=substitute(f3,""" ""","""""")"

I get an error when I try to do this
Expected end of statement

I get lost in the quotes. What is the process of translation?

Thanks

quotes in formulas using vba
 

You have too many quotes, try the following:

Range("A5").Value = "=SUBSTITUTE(F3,"" "","""")"

--
HTH,
Laura Cook
Appleton, WI


"Doug Broad" wrote in message
...
I want to enter the following formula into cell a5

=SUBSTITUTE(F3," ","")

I tried this:

range("a5").value= "=substitute(f3,""" ""","""""")"

I get an error when I try to do this
Expected end of statement

I get lost in the quotes. What is the process of translation?

Thanks

quotes in formulas using vba
 

Thanks Laura!
That worked. So does the outer pair of quotes
for each quoted section allow the inner set to show
up?


"Laura Cook" wrote in message
...
You have too many quotes, try the following:

Range("A5").Value = "=SUBSTITUTE(F3,"" "","""")"

--
HTH,
Laura Cook
Appleton, WI


"Doug Broad" wrote in message
...
I want to enter the following formula into cell a5

=SUBSTITUTE(F3," ","")

I tried this:

range("a5").value= "=substitute(f3,""" ""","""""")"

I get an error when I try to do this
Expected end of statement

I get lost in the quotes. What is the process of translation?

Thanks