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
|