Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Address
If I type a formula in a cell " =C10 ". In another cell I must get result C10.
can any body help me |
#2
|
|||
|
|||
Hi
only possible with VBA. This would require for example the following kind of UDF: public function get_formula(rng as range) if rng.hasformula then get_formula=mid(rng.formula,2,1024) end if end function Now if your formula is in cell B1 use =GET_FORMULA(B1) -- Regards Frank Kabel Frankfurt, Germany Grisha Jose wrote: If I type a formula in a cell " =C10 ". In another cell I must get result C10. can any body help me |
#3
|
|||
|
|||
Hi
Not exactly like you wanted, but: P.e. you want to display value from cell, referenced by strin in cell A1. You can do it with formula =INDIRECT(A1) Now, when you enter into A1 text "C10", in cell with formula the value from cell C10 is displayed. -- Arvi Laanemets (When sending e-mail, use address arvil<Attarkon.ee) "Grisha Jose" <Grisha wrote in message ... If I type a formula in a cell " =C10 ". In another cell I must get result C10. can any body help me |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I import addresses in Excel over to address labels in Wor. | Excel Discussion (Misc queries) | |||
Help me Please!! Need hyperlinks to show actual email address! | New Users to Excel | |||
How do I change an e-mail address in Excel? | Excel Discussion (Misc queries) | |||
how create/maintain Excel "db" of client, output to Avery address. | Excel Discussion (Misc queries) | |||
how do I set up my address book? | New Users to Excel |