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

But this does assume that you have that language version installed.

--

HTH

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


"Dave Peterson" wrote in message
...
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

?zBob 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

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