quotes in formulas using vba

  • Thread starter Thread starter Doug Broad
  • Start date Start date
D

Doug Broad

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
 
You have too many quotes, try the following:

Range("A5").Value = "=SUBSTITUTE(F3,"" "","""")"
 
Thanks Laura!
That worked. So does the outer pair of quotes
for each quoted section allow the inner set to show
up?
 
Back
Top