excel training course - 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