Forum Discussion
Error in macro with a formula that used to work before
Dear all,
I have been using this formula for years, as part of some macros
I have the feeling that the latest Microsoft updates somehow "Blocked" this formula and now I am getting an error.
=IFERROR(@INDEX(sheetlist,ROW()),"")
Any insight on what may have happened and how to solve this issue?
Many thanks in advance,
Alejandro
4 Replies
We'd have to see (a copy of) the workbook...
aparra123 What error? what Excel version are working in?
Tried the formula in a new worksheet, using the latest Excel version. No problem, though you don't need the @-sign.
Riny_van_Eekelen thanks for your response.
to this formula; =INDEX(sheetlist,ROW()) I am getting the error: #BLOCKED!
Here is Microsoft's list of possible causes: How to correct a #BLOCKED! error
