| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel inserts single quote marks into formula
When I use vba to insert this formula:
Sub Macro1() ActiveCell.FormulaR1C1 = "=IF(F12=0," & Chr(34) & Chr(34) & Chr(34) & Chr(34) & ",IF(F12<0.3,0.3-F12," & Chr(34) & Chr(34) & Chr(34) & Chr(34) & "))" End Sub I get this result: =IF('F12'=0,"""",IF('F12'<0.3,0.3-'F12',"""")) How do I stop Excel from inserting the single quotation marks? Cheers, Max |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel inserts single quote marks into formula
You cannot use FormulaR1C1 with an A1 style formula. Try
ActiveCell.Formula = "=IF(F12=0," & Chr(34) & Chr(34) & Chr(34) & _ Chr(34) & ",IF(F12<0.3,0.3-F12," & Chr(34) & Chr(34) & Chr(34) & _ Chr(34) & "))" -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Max Bialystock" wrote in message ... When I use vba to insert this formula: Sub Macro1() ActiveCell.FormulaR1C1 = "=IF(F12=0," & Chr(34) & Chr(34) & Chr(34) & Chr(34) & ",IF(F12<0.3,0.3-F12," & Chr(34) & Chr(34) & Chr(34) & Chr(34) & "))" End Sub I get this result: =IF('F12'=0,"""",IF('F12'<0.3,0.3-'F12',"""")) How do I stop Excel from inserting the single quotation marks? Cheers, Max |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel inserts single quote marks into formula
FormulaR1C1 expects R1C1 references.
Enter Activecell.Formula = "=IF(F12=0,"""",IF(F12<0.3,0.3-F12,"""")" HTH -- AP "Max Bialystock" a écrit dans le message de news: ... When I use vba to insert this formula: Sub Macro1() ActiveCell.FormulaR1C1 = "=IF(F12=0," & Chr(34) & Chr(34) & Chr(34) & Chr(34) & ",IF(F12<0.3,0.3-F12," & Chr(34) & Chr(34) & Chr(34) & Chr(34) & "))" End Sub I get this result: =IF('F12'=0,"""",IF('F12'<0.3,0.3-'F12',"""")) How do I stop Excel from inserting the single quotation marks? Cheers, Max |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paired Quote marks in Excel IF statement | Excel Worksheet Functions | |||
| Writing formula to include quote marks in result | Excel Worksheet Functions | |||
| Unwanted single quote displayed in Formula bar | Excel Discussion (Misc queries) | |||
| Quote marks in Formulas passed from VB Script in Excel | Excel Worksheet Functions | |||
| How to keep quote marks for CSV in excel | Excel Discussion (Misc queries) | |||
![Max Bialystock[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
