hi all, i am facing another problem here.
i want to stop a for loop.
i attach my excile file at here.
it is call as parent if the column "a" is blank n hv alphabet.
if the column "a" is not blank n hv numberic it is call as child.
i want to delete the child if the parent come out a word "mount"
here are my code
![]()
Sub aa() r = ActiveSheet.UsedRange.Rows.Count For i = 1 To r - 1 If InStr(3, Cells(i, 3).Value, "MOUNT") > 0 Then z = i + 1 For z = 1 To r - 1 If Cells(z, "a").Value <> "" Then Rows(z).Select Selection.Delete Shift:=xlUp 'ElseIf Cells(z, "a").Value = "" Then 'stop this for loop and go to find another parent whether hv mount -- this part how to write -- End If Next End If Next i End Sub
Bookmarks