| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a formual with " in it
I want to insert a formula into a specific cell, something like
ActiveCell.FormulaR1C1 = "=EOMONTH (Now(), -1)" This works fine and gives me the last day of last month. But this doesn't work because of the " ActiveCell.FormulaR1C1 = "=Right("0000"&c3,4)" The formula has quotes in it, and the VB chokes as it expects only one set of quotes. --mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting Rows...but losing "FORMAT" | Excel Discussion (Misc queries) | |||
| Inserting Auto Text for "Last Printed On" Date | Excel Discussion (Misc queries) | |||
| "Cannot shift objects off sheet" in Excel when inserting row/col? | Excel Worksheet Functions | |||
| When inserting column I get "cannot shift object off sheet" | Excel Worksheet Functions | |||
| inserting a conditional "go to" command on a excel "if" function | Excel Worksheet Functions | |||
Threaded Mode
