View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
you'll need VBA. e.g. 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

"mototrile_x" schrieb im
Newsbeitrag ...
i need to display 9 cells functions and the rest the value of the

function