Calling function inside function. (aka nested function)

I would like to create printing function which prints entire array or part of it in immediate window. First I have function which determines count of array dimensions. Second I have function which determines longest string in column. Third I want to test these functions, but the test gives me error. The problem is that function 1 is not evaluated in function 2. Is it possible to somehow nest functions? It would make my code much more readable.

1. Determines number of dimmensions

Please Login or Register  to view this content.

2. find the longest string array column

Please Login or Register  to view this content.

3. Calling function

Please Login or Register  to view this content.

Please Login or Register  to view this content.

What is N? This looks like it will always return the same value.


In findLong, What is ar2? similarly ald?

Please Login or Register  to view this content.

You aren't dimensioning your variables and are using them outside of the procedure that they are scoped.
Option Explicit will require all variables to be dimensioned and in scope.

It looks like you might be using variable ar2 within findLong, when the array passed is x. (ar2 is an array scoped only to the Sub testr)

I still don't see where N gets its value in NDim, or what ald is set in findLong.

https://msdn.microsoft.com/en-us/library/y9341s4f.aspx

Mikericson, I have corrected the typos in my code (Ndim=Ndx; nd = NDim(x)). Still It doesn't do what I would like to. Nesting vba function will greatly improve readability of my code. Otherwise I have to use very long function with many parts.

-ald() creates one dimensional array to which string length 'ld' of the longest string from array 'ar2' column is stored. (maximum length for each column)