jwise
10-05-2007, 07:43 AM
I sent a co-worker my spreadsheet that has a macro. It has a statement:
shName = "PNL" & Format(i, "00")
This works fine on my Excel 2003. He uses Excel 2007 and the macro execution is halted at this statement, indicating that there is no "Format" function.
My gut feel is that there is some install option that is wrong if you are going to use macros, but since I don't have '07, I don't know. Has anyone seen this?
shName = "PNL" & Format(i, "00")
This works fine on my Excel 2003. He uses Excel 2007 and the macro execution is halted at this statement, indicating that there is no "Format" function.
My gut feel is that there is some install option that is wrong if you are going to use macros, but since I don't have '07, I don't know. Has anyone seen this?