Do.....Loop until IsEmpty(....)

  • I have a workbook that contains 5 worksheets, i want to loop through only three sheets that contains my data until the match is found(see the macro), then stop the looping and proceed the rest of the macro.......


    here is the full macro with my small try to loop through two sheets(4 and 2)
    i tried it onc using Do....loop and another time using only if........but!!!!!!!


    I attached the file


    would any one pls help.............


    I placed this macro in the stock sheet



    yours
    hesham

    ******************
    [SIZE=6]Yours
    h [/SIZE]

    Your Help Is Highly Appreciated

  • I was unable to view the prorject in your attachment, so I couldn't test, but perhaps the following code will do what you wish.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!