OR formula, translation to swedish please

  • Thread starter Thread starter Guest
  • Start date Start date
Hi Freddie,
I don't know Swedish, but Excel (Swedish language version) does. Write this
in VBE Immediate window:
activecell.Formula="=OR(true,false)"
and you will see the translated formula in the active cell. Otherwise look
up it in an English-Swedish dictionary, XL uses the common language
translations!

Regards,
Stefi


„FreddieP†ezt írta:
 
ELLER

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Hej Stefi, thanx for your help. I just translated it with common language and
it worked but, I didn't get your formula that I find really interesting to
work.

I don't know what a VBE window is?

/Freddie
 
Hi Freddie,

It's worth while to learn to use Visual Basic Immediate window in order to
solve future translation problems, especially if you write macros using
worksheet functions, because in this case you have to know both English and
translated names of worksheet functions (in the spreadsheet you use the
translated name, in VBA the English name, clever, isn't it). I'm also
continuously suffering from my national language (Hungarian) version, because
translations are often arbitrary and cannot be easily found out. It goes like
this:

Tools/Macro/Visual Basic Editor (or with hotkey Alt-F11)

View/Immediate window


Regards,
Stefi



„FreddieP†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MID in Swedish Excel? 3
Arrrgh. Ok please help, formulae language driving me completely ma 5
Problem with Language 10
VLOOKUP output 3
Can I prevent word from translating "default" styles 1
Word Translation from swedish to english 1
Too many rows or columns in my pivot-table 1
fp2003 and XP (swedish) 13

Back
Top