Results 1 to 32 of 32

Multidimensional array

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-20-2008
    Location
    Gloucestershire
    Posts
    134

    Multidimensional array

    I am stuck at the moment with this problem.

    I need to store 2 columns of data into an array Columns 8 and 9.

    I then need to find all matching data in column 8 ie (7X6605,7X6605)(there are 1000's of these combinations)

    With these matching strings i need to sort them by column9 which is time(30/12/1899 09:07:01) so that the erliest time is first.

    I Cant get my head round this problem does anyone know how it can be done.

    Bellow My attempt:
    Sub Serial()
     
    Dim Arr(9999)
    Dim i As Integer
    Dim N As Long
    Dim Arr2(9999)
    Dim i2 As Integer
    Dim N2 As Long
     
    N = 9999
    N2 = 9999
     
    For i = 1 To N
        Arr(i) = Sheet3.Cells(i, 8)
    Next i
     
        For i2 = 1 To N
            Arr(i2) = Sheet3.Cells(i2, 9)
        Next i2
     
     
     
     
    End Sub
    Thanx George
    Last edited by VBA Noob; 02-02-2009 at 08:38 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1