Range.Calculate has always ignored iteration, it just didnt complain until
2002 ...

"Ajtb" wrote in message
...
Thanks for the advice Charles. I had calculation set to manual and
iteration enabled which apparently upsets Excel 2002.

Regards

Andrew B