What are these macros and how do they work? Pretty cool, eh? Download Excel Macros WorkbookĬlick here to download the workbook that has macros to convert IFERROR formulas to ISERROR formulas and vice-a-versa.Ĭlick here to view the VBA Module code. I am pleased to announce that I wrote 2 simple macros, iferror2iserror() and iserror2iferror() that would scan formulas in a bunch of selected cells and convert them from IFERROR to ISERROR and vice-a-versa. But quite a few of my colleagues use Excel 2003 and they see a bunch of #NAME errors when I send them an excel workbook with IFERROR formulas. There is a different set of folks who asked “Wow, this is good. But how can I take a sheet full of =IF(ISERROR(…)….) formulas and convert them to =IFERROR()” Quite a few people reading that page asked, “Wow, this is good. Last Friday, we have learned about an interesting formula – IFERROR Formula using which you can easily handle errors in Excel workbooks.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |