CELL("Contents",ref) effect?

  • Thread starter Thread starter Jack Schitt
  • Start date Start date
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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GETPIVOTDATA #REF! error XL2003/2010 1
Want to avoid a circular ref with an "if" 5
Macro to change formula? 5
Workbook linkage returns #REF! 4
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
Using a #Ref! in a column Sum 3
Dynamic sheet reference 3
how to remove #REF and #N/A 3

Back
Top