| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Inserting a formual with " in it
Hi Mike,
Try doubling the internal quotes: ActiveCell.FormulaR1C1 = "=Right(""0000"" & c3,4)" --- Regards, Norman "Mbt6" wrote in message . .. 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Inserting a formual with " in it
I got a little closer....thanks....
now can I get past a vlookup ActiveCell.FormulaR1C1 = "=Right(""0000"" & c3,4)&Vlookup(e3,'Bank Lookup'$A$2:$B$8,2,False)" I think the ' in the worksheet name is hanging me up now. The first part worked just fine. "Norman Jones" wrote in message ... Hi Mike, Try doubling the internal quotes: ActiveCell.FormulaR1C1 = "=Right(""0000"" & c3,4)" --- Regards, Norman "Mbt6" wrote in message . .. 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Inserting a formual with " in it
Hi Mike,
Try: ActiveCell.Formula = "=Right(""0000"" & c3,4) & " & _ "Vlookup(e3,'Bank Lookup'!$A2:$B$8,2)" --- Regards, Norman "Mbt6" wrote in message . .. I got a little closer....thanks.... now can I get past a vlookup ActiveCell.FormulaR1C1 = "=Right(""0000"" & c3,4)&Vlookup(e3,'Bank Lookup'$A$2:$B$8,2,False)" I think the ' in the worksheet name is hanging me up now. The first part worked just fine. "Norman Jones" wrote in message ... Hi Mike, Try doubling the internal quotes: ActiveCell.FormulaR1C1 = "=Right(""0000"" & c3,4)" --- Regards, Norman "Mbt6" wrote in message . .. 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Inserting a formual with " in it
Hi Mike,
I failed to include your fourth VLookup parameter, so change: ActiveCell.Formula = "=Right(""0000"" & c3,4) & " & _ "Vlookup(e3,'Bank Lookup'!$A2:$B$8,2)" to: ActiveCell.Formula = "=Right(""0000"" & c3,4) & " & _ "Vlookup(e3,'Bank Lookup'!$A2:$B$8,2,False)" --- Regards, Norman |
| Reply |
| 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 | |||
Linear Mode
