Gets the number of bytes of remaining stack space
static USHORT XlGetStackSpace( );
Returns the number of bytes of stack space available.
Excel has a limited amount of stack space available for use by add-in functions. The XLL+ classes have been designed to make optimal use of the stack, and any very large data requirements are allocated on the heap and automatically cleaned up.
However, if your code needs very large amounts of stack space (for instance in a recursive algorithm), then you should check that sufficient stack space is available for your code to run, by periodically calling XlGetStackSpace().
This method is deprecated. Use XlGetStackSpace2 instead.