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.