Duplicate Excel 2010 Function

[joeyiii57]

There is a routine in the smfUtilities_ module name IfError. There is a built-in Excel 2010 function with the same name.

[ClimberMel]

There are no calls to it from any module. I am going to guess it was a formula that Randy used for something. He had a few routines that were for his testing and also fo older versions of Excel. You can't call it in Excel 2010. I changed the name slightly so that I could call it and it returned 0 for a division be zero error but didn't display the error message.

[joeyiii57]

The only reason I noticed it was because I was writing a rather large formula in an excel workbook and kept getting a VBA error but I wasnt actually using any macros. Changed the name and VBA error stopped popping up. I looked for use in other macros and couldn't find any either. Thanks. iii

…

On February 20, 2023 3:42:42 PM EST, ClimberMel ***@***.***> wrote: There are no calls to it from any module. I am going to guess it was a formula that Randy used for something. He had a few routines that were for his testing and also fo older versions of Excel. You can't call it in Excel 2010. I changed the name slightly so that I could call it and it returned 0 for a division be zero error but didn't display the error message. -- Reply to this email directly or view it on GitHub: #18 (comment) You are receiving this because you authored the thread. Message ID: ***@***.***>