Hi all,
I have a workbook which produces #NAME errors in some cells when not connected to a third party application. I would like to know if there is a way to extract some of the text from the formula. I am finding that any formula I write that references the error cell also returns a #NAME error.
For the record, the formula is =EVRNG(E3:E11), and I am trying to extract the E3:E11 part.
(I am about to start on a solution in the third party app, but a solution in the disconnected state would be more robust)
I have a workbook which produces #NAME errors in some cells when not connected to a third party application. I would like to know if there is a way to extract some of the text from the formula. I am finding that any formula I write that references the error cell also returns a #NAME error.
For the record, the formula is =EVRNG(E3:E11), and I am trying to extract the E3:E11 part.
(I am about to start on a solution in the third party app, but a solution in the disconnected state would be more robust)