Hi Max,
Indeed I was, kicking out the z's.
Unfortunately, Excel is not that smart. It is the equivalent of you putting
in semi-colons, like
=IF(A1=17;A1;B1)
same error.
VBA has a strange twist. If you set a formula there, you have to use
English, like
Actyivcell.Formula = SUM(A1:A10)
and it gets translated, so German comes out as =SOMME(A1:A10). I am not sure
if you also have to use commas and it gets translated to semi-colons, I
don't have a continental version of an OS and Excel, but I doubt it as I
would have thought VBA uses the regional settings (but that is purely a
guess, and haven written has set doubt in my mind :-)),.
--
HTH
Bob Phillips
"Max" wrote in message
...
You're probably in deep slumber now, Bob <bg, but when you're up ...
If the OP opens the file posted in her "continental version" of Excel,
would
the formulas therein be automatically converted in terms of the commas to
semicolons, etc ? Thanks.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
|