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. =IFER...
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
