For the best in 3D add-in functionality, check out:

Also, check out the freeware file Make Excel 3D in the CompuServe Excel
forum library for a comprehensive set of 3D custom functions.

Editor’s Note: I’ve never used MOREFUNC.XLL, but I’ve heard a lot of good things about it. Other than the Analysis ToolPack ToolPak, I rarely use add-ins that provide additional worksheet functions. I don’t know why, really. I guess I’m concerned that it makes the spreadsheet less portable. Anyway, if you have good or bad experiences with this one, be sure to leave a comment.

Posted in Uncategorized

3 thoughts on “MOREFUNC AddIn

  1. I wonder why some topics get 100’s of responses, and other equally worthy ones get one response after 2 1/2 years.

    Anyway, I tend to only use UDFs I’ve written myself; I don’t know why really. I have morefunc, it looks really good, and one of these days I’m going to spend some time finding out which of its functions will be really useful to me.

  2. People prefer responding to problems, at least those of us who solve problems for a living.

    Anyway, what’s useful in MOREFUNC?

    THREED — the best udf so far for working with 3D references as arrays (though stacked 2D arrays)
    *.EXT — extensions of statistical functions that handle either much larger ranges/arrays or provide
    much better numerical behavior
    REGEX.* — regular expression text functions

    There are some other handy functions, but there are usually either faster built-in function equivalents (ROW vs INTVECTOR) or they could be implemented fairly simply in VBA. One of the functions, MCONCAT, is much less useful implemented in an XLL than a VBA module because the XLL interface limits returned strings to 255 characters while VBA can return 32767 characters.

Posting code? Use <pre> tags for VBA and <code> tags for inline.

Leave a Reply

Your email address will not be published.