Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
First 3 criteria work but not the 4th, which is looking cells in column "J"
with all start of "HG", anybody can help please? Sub Macro1() Dim i As Long, LastRow As Long Application.ScreenUpdating = False LastRow = Range("A" & Rows.Count).End(xlUp).Row For i = LastRow To 2 Step -1 If Cells(i, "I") = "" Or Cells(i, "J") = "sss" Or Cells(i, "J") = "ccccc" Or Cells(i, "J") = "//" Or Cells(i, "J") = "HG*" Then Rows(i).Delete End If Next i Application.ScreenUpdating = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete Picture VBA If Then Problem | Excel Programming | |||
Delete row problem, could some help me on that? | Excel Programming | |||
Delete problem | New Users to Excel | |||
Delete Sheets Problem | Excel Programming | |||
Name Delete Problem Again | Excel Programming |