Problem with Language

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" <Robert57.20fnsm_1135240800.7578@excelforum-nospam.com> wrote in
> > message news:Robert57.20fnsm_1135240800.7578@excelforum-nospam.com...
> > >
> > > 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" <petersod@verizonXSPAM.net> wrote in message
news:43AABDB3.185E82B1@verizonXSPAM.net...
> 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" <Robert57.20fnsm_1135240800.7578@excelforum-nospam.com>
wrote in
> > > message news:Robert57.20fnsm_1135240800.7578@excelforum-nospam.com...
> > > >
> > > > 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" <Robert57.20fnsm_1135240800.7578@excelforum-nospam.com> wrote in
> > > message news:Robert57.20fnsm_1135240800.7578@excelforum-nospam.com...
> > > >
> > > > 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
>