Decimal problem
syntax for format is wrong
"=RC[4] / (" + Format(100 - dblNewProdSaving ,"0.00" ) + " / 100)"
but i suggest
with rangetarget
.formulaR1C1 = "=RC[4] / (" & (100 - dblNewProdSaving ) & ")"
.NumberFormat ="0.00%"
end with
format the result generally overcomes issues with results that can often
unexpectedly occur when an interim calculation is formatted , eg rounding
issue
"Gustaf" wrote in message
...
In a VBA project I'm supporting, I ran into a line where a cell is
assigned the value
"=RC[4] / (" + Format(100 - dblNewProdSaving) + " / 100)"
I get a run-time error on this line. However, if I manually change the
cell from where dblNewProdSaving is taken, from 0,02 to 0.02, it runs. Why
is this and what can I do about it?
Gustaf
|