Arrays

The UK's most regular instructor-led training courses.
Training information: excel course · Excel training courses · VBA training in London

Resolved · Low Priority · Version 2003

Arrays

Nandana has attended:
Excel VBA course

by - delegate Nandana [1 post] (2008 May 1 Thu, 16:49) Reply

What is an array?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Southwark	3	book now	£224	£235
2003	2008 Sep 3 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	6	book now	£214	£230
2003	2008 Sep 12 Fri	Southwark	7	book now	£203	£230
Full Schedule: See all 127 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Arrays

by - trainer Carlos gold contributer [391 posts] (2008 Jun 3 Tue, 10:07) Reply

Nandana

In computer terms an array is a data structure consisting of elements that are accessed by indexing.

In most programming languages each element has the same data type and the array occupies a contiguous area of storage.

In VBA as with most other languages Variables normally only store a single value but, in some situations, it is useful to declare a variable as an Array that can store a series of related values.

The indexing in an array begins at 0 so declaring an array as

Dim SalesYear(5) as Integer

will allow you to store 6 years (0 t0 5)

Then in the code SalesYear(3) will return the value stored in that section of the array

Hope this helps

Carlos