Error in macro with a formula that used to work before

Copper Contributor

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

@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.

 

@aparra123 

We'd have to see (a copy of) the workbook...

@Riny_van_Eekelen thanks for your response.

to this formula;  =INDEX(sheetlist,ROW())  I am getting the error: #BLOCKED!

@aparra123 

Here is Microsoft's list of possible causes: How to correct a #BLOCKED! error