Hi Gérard,

Please post the code of the Sub

--
Kind regards,

Niek Otten

"Gérard Ducouret" wrote in message
...
Hello,
I'm using Excel 2003 French version.
In a spreadsheet, I have a serie of dates such as 1-févr-06; 15-févr-06;
1-mars-06; 15-mars-06... (with an abbreviation of the French months name)

A VBA Sub creates range names by doing the equivalent of: Insert / Names
/
Create / Upper row.
This sub worked fine in Excel 2000.
In the 2003 version, all range names are created with the English format :
for ex. _15_Feb_06 instead of _15_févr_06.
Of course, the following sub doesn't find anything!
How can I fix this issue?

Thanks for your help

Gérard