suspect it has more to do with what is contained in your variables than
anything to do with the version of Excel.

--
Regards,
Tom Ogilvy

"Jimmy" wrote in message
...
Please advise why when this macro run on Excel 2003, it give a Run-time
error
"13" Type mismatch?

Balance = Format(GrandTotal.Value - Pyt01.Value - Pyt02.Value -
Pyt03.Value,
"$#,##0.00")

I do not encounter such problem running it on Excel 97 and Excel 2000.

Thank you.