Hello,

I've never fully understood the "looping" process and for each time I've had a requirement I've had to go asking for help. Each time I've read and read and tried umpteen examples to no avail. Attached, for this instance, is what I have after I cleaned up my crazy, messy and just more or less guessing efforts. I'm hoping if someone can help me figure this out then maybe it'll be that little bit more to help me better understand it.

This code does the trick row by row with each button click but I want it to "loop" through all the rows with one click until the last item.

Any help is greatly appreciated!

Andy

'Clear all shipped sku's

    Dim fba_template As Worksheet
    Dim rng As Range
    Dim c As Object
            
    Set fba_template = ThisWorkbook.Worksheets("FBA Ship Template 2017")
    Set rng = fba_template.Range("X3:X228")
        
    If rng.Cells.find(what:="6. Shipped").Select Then
    ActiveCell.Value = ""
    ActiveCell.Offset(0, 1).Value = ""
    ActiveCell.Offset(0, -20).Value = ""
    ActiveCell.Offset(0, -22).Value = ""
    ActiveCell.Offset(0, -13).Value = ""
    ActiveCell.Offset(0, -13).Interior.Color = xlNone
    End If
    
    'Exit For
    'End If
    'Else
    
    'Next c