And once more, Bob,

I sometimes feel that it would be much better if Excel
uses the English expressions for formula even in the
cells, no matter which language Excel itself is... because
all the translations and the mental switching between the
VBA and the cell contents is sometimes very bothering...
for example: at university we have German Excel and
everytime I'm forced to write something there I have to
lookup what all the formula is called in German - because
sometimes its not an obvious translation like "Mittelwert"
and "Average" ... so I am happy to have English Excel
here...

Nevertheless, this has nothing to do with this thread, but
I felt I needed to write it out of my soul ;o)

Best

Markus


-----Original Message-----
Thanks Albert, that confirms what I had been told (I have
an English
version, so cannot check). It's kinda neat that Excel
translates it though
:-)

BTW, to get the English version, you can type the local
name in a cell as a
proper formula, and then in the VB IDE, type this in the
immediate window
?activecell.formula
and it gives you the English

Bob

"Albert" wrote in message
.. .
Hi Bob,

You're right about that, I had to change the formula to
=Average.
I kinda expected this error, because formula's in cells
are called
"formule's" in
my Dutch version. But in VB its Formula, like in the
code you gave me.

So everything else in cells is different too. Like IF
is ALS. I think it
was
a big
mistake to translate it for cells and not for VB (and I
mean: it shouldn't
have
been translated at all). This is very confusing.

If you need to know anything else, let me know!

Albert


"Bob Phillips"
schreef in bericht
...
Albert,

Something I forgot to mention.

Apparently, when creating cell formulae using VBA,
you should enter the
formula in English, with US English separators (such
as a comma rather
than
a semi-colon), and let Excel convert it to the local
form. So in your
example, it seems that you should use

.Formula = "=AVERAGE(F2:H2)"

I would be interested in your experience.

--

HTH

RP
(remove nothere from the email address if mailing
direct)


"Albert" wrote in message
...
i = 35562
With Range("E2")
.Formula = "=GEMIDDELDE(F2:H2)"
.AutoFill Destination:=Range("E2:E" & i),
Type:=xlFillDefault
End With

Sub dropdown()
For i = 1 To 35562
Range("I" & i).Formula = "=Gemiddelde(F" & i
& ":g" & i
& ":h" & i & ")"
Next i
End Sub

Thanks guys, this is excellent!

Albert








.