View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jmealhouse jmealhouse is offline
external usenet poster
 
Posts: 2
Default 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