If Excel didn't understand the formulas because the functions should be in
German, then you would get #Name? errors. Not #N/A or #Value errors.

However, you said you were working on cleaning up the VBA - so does the code
enter these formulas into the worksheet? If so, then they should be written
using english conventions and the Formula property (rather than
FormulaLocal).

Then I would suspect your problems are due to the data being processed.

--
Regards,
Tom Ogilvy




"TCook" wrote in message
...
Hey All,

I've been given the task of trying to localize a large, disorganized VBA
solution. I was wondering if any of you might know why formulas like the
following might give me errors:

=IF(AND('A01'!U76=3,'A01'!U76<=1000),1,"")
=IF(DM31="","",MATCH(DM31,$AB$202:$AB$450,0))
=IF(AB205="","",VLOOKUP(AD205,$CE$4:$CF$20,2,0))

I am getting lots of #N/A and #VALUE errors. The solution runs fine in
English.

Could there be number formatting issues that I also need to be aware of?

Any advice or experience offered would be appreciated.

Regards,

TC