Gerald has attended:
Excel Advanced course
Array formulie
Hi
Could somepne please enlighten me as to the maximum number of variables that an array formula can support, and also can it reference woorkbooks on different servers if all the books are opened and refreshed?
Thanks in advance.
Kind regards,
Gerald
RE: Array formulie
Hi Gerald. According to this:
http://support.microsoft.com/kb/177991
The maximum number of elements is 6,550, before you get an Out of Memory error message. To get around that I'd just set up successive arrays. Secondly, you shouldn't have any problems sending information to your arrays from workbooks on different servers, but you might have to assign the filepath of those workbooks to a variable, than use the raw path.
Hope this helps,
Anthony
