where <name> is a locally defined name, you receive the following run-time error:
Application-defined or object-defined error
This syntax is incorrect because the locally defined name is not qualified with the name of the worksheet.
This behavior is by design of Microsoft Excel.
NOTE: Microsoft Excel 5.0 and 7.0 allow this syntax, and they return the expected results if the sheet that contains the name is the active sheet when you run the macro.
ID d'article : 213540 - Dernière mise à jour : 10 oct. 2006 - Révision : 1