Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stock Quotes | Excel Discussion (Misc queries) | |||
change straight quotes to curly quotes | Excel Discussion (Misc queries) | |||
How do i get historical stock quotes using MSN Money Stock Quotes | Excel Discussion (Misc queries) | |||
Using CSV and quotes | Excel Discussion (Misc queries) | |||
Using Quotes in Formulas | Excel Discussion (Misc queries) |