+ Reply to Thread
Results 1 to 6 of 6

How to use this loop ?

  1. #1
    Forum Contributor
    Join Date
    07-18-2006
    Posts
    135

    How to use this loop ?

    Dear all,

    Please open my file, enable macro, then Ctrl D to run it

    i wanna check what items in DRP sheet, that does not exist in LoadingPlan sheet, If it's not, then msgbox "shortage this item"

    it's rough here, and there is some blank cells at columns E

    Please Login or Register  to view this content.
    How to loop to end of last row including blank cells inside range

    Thanks in advance
    Attached Files Attached Files
    Last edited by vumian; 10-11-2007 at 09:53 AM.

  2. #2
    Registered User
    Join Date
    10-11-2007
    Posts
    5
    Hi vumian,

    Its not exactly you asked for, but have a look at column R.
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    09-09-2005
    Location
    England
    MS-Off Ver
    2007
    Posts
    1,500
    The previous reply is potentially more useful, as the same value cam be missing more than once in the second sheet, and indeed is in your sheet

    try this as the macro

    Please Login or Register  to view this content.

    and if you wish comment out the msgbox and include the line above it which is green

    does that help

    regards

    Dav

  4. #4
    Forum Contributor
    Join Date
    07-18-2006
    Posts
    135
    Dear Dav,

    Your code is good, If multiple Itemcode is the same at separate multiple rows, then i wanna msgbox once inteads of your currently code get many loop

    Thanks in advance

  5. #5
    Forum Expert
    Join Date
    09-09-2005
    Location
    England
    MS-Off Ver
    2007
    Posts
    1,500
    thats why i suggested the option with the line above being used and the comment line being disabled. How about the following option
    Please Login or Register  to view this content.
    is that what you want

    Regards

    Dav

  6. #6
    Forum Contributor
    Join Date
    07-18-2006
    Posts
    135
    hi Dav,

    Thank you a lot

    all the best,
    vumian

+ 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