Migration of VBA macro pb

Hello everyone,

I'm now migrating all the macros from Excel 2002 to Excel 2007.

Normally, that don't give any pb, but I observe that, some errors rn't accetable in Excel 2007

1. every variable need to be declare before the use
2. [ ] to get a range value from worksheet return a compilcation error
3. the functions like Format, Ucase don't exist in

Can u give me other difference u found in ur work? I don't find a good reference in MSDN technical doc, that can be very useful, I think

Is there a way to just use directly the old macro in 2007?

thx

[625 byte] By [YellOwCN] at [2008-1-7]