View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kevin Vaughn Kevin Vaughn is offline
external usenet poster
 
Posts: 111
Default how to get formula content of a cell?

I'm glad I qualified my answer. However, I believe that there is a potential
problem with this solution. I tested it and it did work, however, this is
probably a function leftover from Excel's previous macro language (the name
of which escapes me, something like xmla,) which I have read can cause (I
believe) a crash if copied to other worksheets in certain versions of Excel
(something like that.) If someone reads this and knows the exact scenario,
hopefully they'll respond with the specifics.
--
Kevin Vaughn


"Beege" wrote:

Muster,

Found this, too... and no VBA

http://www.mcse.ms/archive144-2005-5-1637686.html

Beege

"muster" wrote in message
ups.com...
For example

A1: =b2+c2, result is 5

I'd like to get "=b2+c2", not 5, without VBA.

Thank you.