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

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

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

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