Since I routinely operate with iteration enabled, your spreadsheet works just fine for me. I can replace the currentvlaue() UDF with F9, and the formula works just fine without needing VBA. Are you allowed to enable iteration? Are you comfortable with that option?