Hi,

I am trying to run the below code to turn indirect to direct references on an excel that uses the indirect function (referencing cells containing the filename, sheet and defined named range) to pull data from separate workbooks.

The code works apart for the instance where the data is being pulled using an array formula. Errors evaluating the edited cell result in the cell not being edited. Any advice on how to address this problem would be greatly appreciated!


Please Login or Register  to view this content.
Best,

Alex