Hi,
I am looping through a list of items and if a certain cell is blank i am to skip the next couple of steps and go to the next item in the loop
inside the loop i have attempted this, but it wont compile so obviously there is something wrong
ranInd is a range, so if this value is blank i want to go to the next range
cheers
VB Code:
If ranInd.Cells(9).Value <> "" Then Next i End If




Reply With Quote