Extract formula from cell without VBA

[Abhay]

Please see attached file.

I am not what is formula =Get.cell(6, ref) is as no help is available in excel. Also, if this is working in define names why is it not working directly in cell if i enter.

I found this trick actually very helpful.

Also, is there a way if I can define this as UDF and store in my personal macro book so that it is available everywhere.

 

[r1c1]

This is a old Excel 4 macro function. MS kept it for backward compatibility reasons. See below pages for help on GET.CELL()

http://www.mrexcel.com/forum/excel-questions/20611-info-only-get-cell-arguments.html


And if you are using Excel 2013, you can do the same with this formula.

=FORMULATEXT(cell_ref)