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