Vedr: [ExcelVBA] activecell.formula translates to english

 

Thank you Bob for your quick, easy and "just to the point"-solution. Works just like expected.

Torstein

Den Fredag, 21. mars 2014 16.05 skrev Bob Phillips <bob.phillips@dsl.pipex.com>:

 

Try

 

ActiveCell.Offset(1, 0).Value = "'" & ActiveCell.FormulaLocal

 

From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf Of Torstein Johnsen
Sent: 21 March 2014 14:42
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] activecell.formula translates to english

 

 

Little activity in the last months, may be someone can help me with this one:

 

I like to write the cell formula in the cell next to the active cell by this sub

 

Sub Makro3()

'

    

    ActiveCell.Offset(1, 0).Value = "'" & ActiveCell.Formula

    

 

End Sub

 

It works very well, but it translates the formula from norwegian (my excel version) to english

 

My formula in the active cell is =hvis(B3=3;3;5) and in the cell next to it I get  =if(B3=3;3;5)

 

Thank you for helping me!

 

Torstein

 

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (3)

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___