that makes a pretty big difference!

so
"=RC[4] / (" & (100 - dblNewProdSaving ) & ")"

should be

"=RC[4] / (" & (1 - dblNewProdSaving ) & ")"


"Gustaf" wrote in message
...
Patrick Molloy wrote:

what's the value in dblNewProdSaving when you step through?

The value is 0,02 in the cell and still 0,02 when transfered to
dblNewProdSaving. If I change the cell to 0.02 the value of
dblNewProdSaving becomes 2 when I step through. Looks odd but probably
makes sense, because the variable is a percentage.

Gustaf