search

ClimberMel / SMF_Add-in

Stock Market Functions for Excel using VBA
https://climbermel.github.io/SMF_Add-in/
14 stars 5 forks source link

Duplicate Excel 2010 Function #18

Closed joeyiii57 closed 1 year ago

joeyiii57 commented 1 year ago

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

ClimberMel commented 1 year ago

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 commented 1 year ago

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: https://github.com/ClimberMel/SMF_Add-in/issues/18#issuecomment-1437522674 You are receiving this because you authored the thread.

Message ID: @.***>