I am working with a group of very complicated offset formulas. I need to see which cells they reference (excel visually highlights the cell off of which the offset is based). The offsets are to a large degree, so I can't manually use my mouse or arrow keys to navigate to them. I can use the
cell() function to find the answer - by manually pasting the full
offset() formula into the second argument of the
cell() function. However this is onerous, and I am working with hundreds of such offset formulas, and I dont have time to manually paste all of them.
Manually, if I type
cell("address", OFFSET(D50, 5, 5)) it works fine.
I can get the offset formula alone using
formulatext(A1). However, the following fails:
Even if I use an additional cell to store the result of
formulatext(), that still doesn't work.
Is this possible for the