Iowa State University

To access elements of a 2- D array, use two indices, e.g. Company(1,2) would access the element in row one and column two. Minimize the number of fixed constants in your code by using functions such as. UBound. Dim Company(1 To 3, 1 To 2) As String. Dim rw As Integer, cl As Integer. For rw = 1 To 3. For cl = 1 To 2. Company(rw, cl) = Cells(rw ... ................
................