Re: #NAME?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 03/31/04 

Date: Wed, 31 Mar 2004 10:25:43 -0500

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" <anonymous@discussions.microsoft.com> wrote in message
news:c4e0dg$6rs$1@s1.read.news.oleane.net...
> For speed reasons when I have to pste a lot of formulas in a ***, 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
>
>
Quantcast