Excel4 Macro Referring to cells in Formula - Refer to any cell

[kev_]

With Named Range "MyFormula" refers to:

Please Login or Register  to view this content.

AND..... type this into any cell (without brackets) to return the formula text of the adjacent cell on the left

Please Login or Register  to view this content.

Is it possible to adapt this to make it more universal so that I do not have to be in same position relative to a target cell each time?
(somehow need required cell reference in the formula )
- workbook attached

Thanks for reading
Kev

NOTES:
1. This is to solve another thread.

2. Options rejected:

UDF option: (OP does not want VBA)

Please Login or Register  to view this content.

with this in cell:

Please Login or Register  to view this content.

Formula Option: (not available - OP using Excel 2003)

Please Login or Register  to view this content.

[Glenn Kennedy]

Halfway house... use this as the NR

=GET.CELL(6,Sheet1!$A2)

your "myformula" formula can then start in any column, row 2...

[xlnitwit]

Hi,

The only close way I can think of would be to use a cell that is in a fixed relative position to your MyFormula cell(s) to supply the address of the cell whose formula you wish to retrieve.

[kev_]

Thanks Glenn
- that's better than I managed
- that method would allow either a column or a row to have the same formula

[kev_]

@xlnitwit - that looks promising. I will play around with that idea later
thanks