CELL("Contents",ref) effect?

J

Jack Schitt

Can someone please tell me what is the difference between the values
returned by
=CELL("Contents",ref)
and
=ref
?

Is there a way (without VBA) of returning the formula of a cell as a text
string?

Thanks
 
F

Frank Kabel

Hi
it only return the upper left cell content from a range.
For your second question: No (unless you want to use Excel 4 macro
functions which I would not recommend)
 
Top