+ Reply to Thread
Results 1 to 5 of 5

Loop question

  1. #1
    Registered User
    Join Date
    06-27-2007
    Posts
    26

    Loop question

    Hi Guys


    I am struggling on some VBA code to put a value in column based on the cell cell value...

    I would like the code to loop through Column A from cell A5 until it finds a blank cell and then stop. If it comes across a value which is in the table in Column H it will to assign the value in Column I to Column C. Pretty similar to a vlookup....


    I hope this makes sense.. I have attached a spreradsheet which may help...

    Any help would be great


    Thanks
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    11-17-2006
    Posts
    152
    Try this code it works on that example book you posted

    Please Login or Register  to view this content.
    hope this helps,

    Jon

  3. #3
    Valued Forum Contributor
    Join Date
    12-16-2004
    Location
    Canada, Quebec
    Posts
    363
    Maybe this can help, I am sure there is simpler way, but it should do the trick

    Please Login or Register  to view this content.
    Denis

    Please always attach the sample workbook without sensitive information when asking for help

    To add a module
    Press Alt + F11 (this is the Visual Basic Environment)
    Insert Menu, select Module
    Past code there
    Close Visual Basic Environment (X)

  4. #4
    Forum Contributor
    Join Date
    11-17-2006
    Posts
    152
    its funny how many mays a problem using code can be solved and the competley difference approaches!

  5. #5
    Registered User
    Join Date
    06-27-2007
    Posts
    26
    fantastic... thanks everyone ;-)

+ Reply to Thread

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