Results 1 to 3 of 3

search numbers in 2 cols

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-12-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    219

    search numbers in 2 cols

    Hi All:

    I'm just starting to use VB and I have a little problem in which I need as much help as possible:

    I have a path of number

    1 2 3 4 5
    ..........6 7
    This path of number can be write in two columns of numbers:
    1 2
    4 5
    2 3
    3 6
    7 6
    3 4
    I want to write a program that will start out to search for number 1 in col 1, if it is found in col1 then it next number is in col2, if it is found in col2 then its next number is in col1. I want the program to map it out so it will look like this:
    1 2 3 4 5
    1 2 3 6 7

    Notice the number start to split at 3 to 3 4 and 3 6. My program right now just pick the first path and finish it without coming back to the second path, I need help with a code so that it can come back for the second path.

    I will be very thankful if someone can help me with this.

    Sincerely,

    VBisgreat

    sorry, I couldn't draw the path into a ---< shape
    1 2 3 4 5
    ..........6 7
    Last edited by VBisgreat; 05-12-2009 at 04:48 PM.

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