| 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 |
| 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 | |||
Threaded Mode
