Across the years, I have posted several versions of the following routines. They all have the in common that they can handle huge argument values (see the comments above the function declarations for the various limits). Because they have been developed at widely varying different times, there is no real consistency to error handling (some have it, some don't... those that do may differ in the method). Each of these functions should be able to be used as a UDF if needed. Whether being used as a UDF or a support function for other VB code, note the need to pass large numeric value as strings and the need to receive large numeric return values as strings so as to avoid conversions into scientific notation.
Bookmarks