Use of Format function in Excel marco
 

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.

Use of Format function in Excel marco
 

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.