Hi,
Is it possible to have a macro which would remove the entire row if column F is ZERO and column G is blank. Also I would only want this to happen from rows 4 to 764
Any ideas would be perfect!
Thanks
Hi,
Is it possible to have a macro which would remove the entire row if column F is ZERO and column G is blank. Also I would only want this to happen from rows 4 to 764
Any ideas would be perfect!
Thanks
One way:
![]()
Sub Del_Rows() Dim lngLoopRow As Long For lngLoopRow = 764 To 4 Step -1 If Cells(lngLoopRow, 6) = 0 And Cells(lngLoopRow, 7) = "" Then Rows(lngLoopRow).Delete End If Next lngLoopRow End Sub
Another would be to use autofilter.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Another example using autofilter which assumes you have headings in row 3:
![]()
Sub Del_Rows() With Range("A3").CurrentRegion .AutoFilter Field:=6, Criteria1:="0" .AutoFilter Field:=7, Criteria1:="=" .Offset(1, 0).Resize(.Rows.Count - 1, .Columns.Count).SpecialCells(xlCellTypeVisible) _ .EntireRow.Delete .AutoFilter End With End Sub
Dom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks