| 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 |
| 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) | |||
Threaded Mode
