Thanks Dave and Bob, that is the case, I run a Hungarian version, and this
translation method works nicely!
Regards,
Stefi
Dave Peterson ezt *rta:
Yep.
In the immediate window:
activecell.formula = "=yourformulahere"
Remember to double up your quotation marks if have them:
activecell.formula = "=if(a1="""","""",a1)
And if you have the formula in R1C1 notation:
activecell.formular1c1 = "=yourformulahere"
(And make sure that the activecell is where you want it <vbg.)
Stefi wrote:
Hi Bob,
Is there a similar way in the opposite direction? E.g. if I receive a
function tip from you in English, does XL have any feature that translate it
into a national language?
Stefi
âžBob Phillipsâ ezt Ã*rta:
Robert,
If you enter a function in a cell, and then go into the VBIDE (Alt-F11), in
the immediate window (Ctrl-G), just type
?Activecell.Formula
this will give you the English equivalent, as VBA works in English.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Robert57" wrote in
message ...
Hi
I'm new here and first problem is for me what to call a function in
english. I'm running a swedish Excel so Do you have a translation table
or something so I know what to write so you understand.
Robert
--
Robert57
------------------------------------------------------------------------
Robert57's Profile:
http://www.excelforum.com/member.php...o&userid=29838
View this thread: http://www.excelforum.com/showthread...hreadid=495444
--
Dave Peterson