View Single Post
  #2   Report Post  
David McRitchie
 
Posts: n/a
Default

HI Olivier,

I don't think the formula you provided does anything.

If you are asking how to generate one specific formula, and perhaps
actually in the form more like
=pesonal.xls!GetFormula(A32) when active cells is B32

See Right Click Menus (Context Menus) in Excel
: http://www.mvps.org/dmcritchie/excel/rightclick.htm
which provides your choice in the context menu

The code for GetFormula is in
http://www.mvps.org/dmcritchie/excel/rormula.htm
which is why I am guessing that this is the kind of thing that you
want, as GetFormula obtains the formula from another cell.

Kind of hard to ask a question when you don't really have an idea
of what kind of solution you are looking for. It sometimes helps to
indicate how you are using it or what it does to help define the need.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Olivier SOW" wrote
I have an excel's worksheet with cellule having the same formula.
I change often this formula.
Existing a way to make something like bellow ?
=FORMULA(CELL(A1))

=FORMULE(CELLULE(A1)) -- in French