No time free yet to test what you propose
The only point is that if I really have to go through all of cells one per
one then all of the benefit won while pasting through an array would be
lost... Thanks once more for your contribution... have a good day
Alain79

"Tom Ogilvy" wrote in message
...
Try selecting all the cells and doing

edit=Replace
what: =
With: =

If that makes the formulas work, then implement it in code.

--
Regards,
Tom Ogilvy



"Alain79" wrote in message
...
Thanks Tom for your contribution - In fact I already proceed that way
for
already a long time, I even had to pay attention to the list separator
but
now with Excel 2003, things that were working correctly in English -
German
and French with Excel 2000 are not any more working...

The formula are corrrectly entered with correct language and correct
list
separator but do need I place the pointer inside the formula editing
area
and press enter in order to have them working properly rather displaying
#NOM? (#NAME? in English)-

That is precisely the new problem I have to face... As if Excel 2003 was
doing less than its previous version in this specific domain... In Excel
2000 I could see very very briefly the #NOM? displayed in the cell then
the
formula works well

Have a good day
Thanks and Bye

"Tom Ogilvy" wrote in message
...
If you are putting formulas in a french version, then the formulas
will
have
to be written as you would enter them by hand in the french version.
Same
for german. You can't write the formulas in English and put them in
the
cells with an array and expect them to be translated as they would if
you
used

ActiveCell.formula = "=English formula"

You are essentially "pasting" formulas as Text, and when they get in
the
cell, they are then interpreted by Excel. This by passes the step
where
they would be translated.

--
Regards,
Tom Ogilvy

"Alain79" wrote in message
...
For speed reasons when I have to pste a lot of formulas in a sheet,
I
paste
them first in an array, then the array on a range...

No probelm with EXCEl2000 and this whatever could be the
multilanguage
selected assuming the basic Office is English

With Excel2003
- it works when Office multi language is settled to English
- it doen't work when settled to French or to German - In that
situation
Cells with formulas involving names display #NAME? and if I place
the
pointer inside the formula editing area and press ENTER the problem
dissapear !!!

Is there someone from the Excel programmer community that could help
me
on
this silly problem... I am more or less either looking how through
vba
to
realise this 'Enter' reparation or even better looking for the Excel
parmeter that is not settled the same way than in Excel2000

Thanks a lot to the ones that can help me
Alain79