| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro converts formula using imbeded literals
I created a macro. In the macro was a formula. When I run the formula it puts
single quotes around the cell position. ActiveCell.FormulaR1C1 = "= (g2*(h2/100)*I2)/360" In the Cell -- See g2-h2-I2 =('g2'*('h2'/100)*'I2')/360 What gives? James |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro converts formula using imbeded literals
Don't use the FormulaR1C1 property. Use Formula instead.
ActiveCell.Formula = "= (g2*(h2/100)*I2)/360" "jmealhouse" wrote in message ... I created a macro. In the macro was a formula. When I run the formula it puts single quotes around the cell position. ActiveCell.FormulaR1C1 = "= (g2*(h2/100)*I2)/360" In the Cell -- See g2-h2-I2 =('g2'*('h2'/100)*'I2')/360 What gives? James |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro converts formula using imbeded literals
Hi jmealhouse
try, Formula ActiveCell.Formula = "= (g2*(h2/100)*I2)/360" -- 天行健，君*以自強不息 地勢坤，君*以厚德載物 http://www.vba.com.tw/plog/ "jmealhouse" wrote: I created a macro. In the macro was a formula. When I run the formula it puts single quotes around the cell position. ActiveCell.FormulaR1C1 = "= (g2*(h2/100)*I2)/360" In the Cell -- See g2-h2-I2 =('g2'*('h2'/100)*'I2')/360 What gives? James |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro converts formula using imbeded literals
That worked!
Thank You James "chijanzen" wrote: Hi jmealhouse try, Formula ActiveCell.Formula = "= (g2*(h2/100)*I2)/360" -- 天行健，君*以自強不息 地勢坤，君*以厚德載物 http://www.vba.com.tw/plog/ "jmealhouse" wrote: I created a macro. In the macro was a formula. When I run the formula it puts single quotes around the cell position. ActiveCell.FormulaR1C1 = "= (g2*(h2/100)*I2)/360" In the Cell -- See g2-h2-I2 =('g2'*('h2'/100)*'I2')/360 What gives? James |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Disappears, converts to a value | Excel Worksheet Functions | |||
| Macro that converts xls to csv | Excel Worksheet Functions | |||
| Excel converts formula to number | New Users to Excel | |||
| Does anyone have an excel macro that converts states to 2 digit f. | Excel Programming | |||
| Help - This macro converts my text numbers. | Excel Programming | |||
Linear Mode
