One Dimensional Array
. C Programming Basics. C Data Type & Variable.
C Programming Operators. C Flow of Control. C Standard Library Functions. C Programming Functions. C Arrays & Strings.
C Data Structure. C Programming Pointers. C File Handling. C Object Oriented Programming. C Programming Advance.
C Programming Examples. C Programming Test. Give Online Test.
One Dimensional Array
Dim Films(1 To 5, 1 To 2) As StringDim i As Integer, j As IntegerFor i = 1 To 5For j = 1 To 2Films(i, j) = Cells(i, j).ValueNext jNext iMsgBox Films(4, 2)Result when you click the command button on the sheet:Explanation: the first code line declares a String array with name Films. The array has two dimensions. It consists of 5 rows and 2 columns. Tip: rows go first, then columns. The other two variables of type Integer are used for the to initialize each element of the array. Finally, we display the element at the intersection of row 4 and column 2.