Does anyone have some VBA that does this? I have code that works for a simple indirect, but I can't fathom how to convert when the indirect is within a function and there are multiple references making up the rest of the path
eg if the workbook is in A1 and the sheet name is in A2 etc etc
=SUM(INDIRECT("'["&$A$1&"]"&$A$2&"....
help gratefully received!
Pete
eg if the workbook is in A1 and the sheet name is in A2 etc etc
=SUM(INDIRECT("'["&$A$1&"]"&$A$2&"....
help gratefully received!
Pete