#NAME?

[Alain79]

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

 

[Tom Ogilvy]

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.

 

[Alain79]

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]

Try selecting all the cells and doing

edit=>Replace
what: =
With: =

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

 

[Alain79]

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