LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Harlan Grove
 
Posts: n/a
Default

xisque wrote...
....
Thanks, that was the answer. Do you know if there is a dictionary to
translate excel functions to my language ?

....

There may be such a dictionary, but you could do this with VBA. If you
name an unlocked cell XYZ, you could use a macro like

Sub x()
Dim f0 As String, f1 As String

f1 = InputBox(Prompt:="Enter formula", Title:="Formula Translation")

If f1 < "FALSE" Then
f0 = Names("XYZ").RefersToRange.Formula
Names("XYZ").RefersToRange.Formula = f1
MsgBox Prompt:=Names("XYZ").RefersToRange.FormulaLocal, _
Title:="Formula Translation"
Names("XYZ").RefersToRange.Formula = f0
End If

End Sub



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Absolute Worksheet reference number Tony M Excel Discussion (Misc queries) 4 March 21st 05 06:10 PM
How do I reference values from 200 worksheets onto a summary sheet mac849 Excel Discussion (Misc queries) 4 March 17th 05 09:26 AM
How do I reference non-contiguous columns in another sheet and th. Bill Nash Excel Discussion (Misc queries) 3 March 3rd 05 05:47 PM
Need formula for sheet & cell reference MPH Excel Worksheet Functions 0 January 16th 05 03:39 PM
Naming & renaming a sheet tab Cgbilliar Excel Worksheet Functions 1 November 7th 04 05:57 PM


All times are GMT +1. The time now is 08:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"