excel training course - Array formulie

The UK's most regular instructor-led training courses.
Training information: excel training course · Advanced.excel · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Array formulie

Gerald has attended:
Excel Advanced course

by - delegate Gerald [1 post] (2007 Aug 15 Wed, 09:52) Edited on 2007 Aug 20 Mon, 15:44 Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	6	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Array formulie

by - trainer Anthony gold contributer [113 posts] (2007 Sep 25 Tue, 10:11) Reply

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

· Microsoft Excel Courses Teach Advanced Macro Techniques
· Creating Charts with Excel
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· How Small Businesses Profit from Outside Excel Training
· Microsoft Excel Training Course

Excel tip:

Quickly create a list of numbers

The fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

View all Excel hints and tips