Arrays

Hi Jan

Thank you for your question

An array can be thought of as a virtual table that can hold multiple values.
You must first declare an array in the same way as you would declare a variable.

e.g

Dim myArray(5,6) as integer

Would declare an array of 5 "rows" and 6 "columns" that would contain integer data.

You can then set the different "cells" of the array equal to particular values

e.g

myArray(1,1) = 323

Sets the first row, first column value to 323.

To compare a set of values in an array to a variable you would normally cycle through the array checking each value against your variable

The following code cycles through each row and column and checks each value against a particualr variable and executes some code if a match is found

For i = 1 to 5



For j = 1 to 6



if myArray(i,j) = Variable then



EXECUTE CODE



End if



next j



next i