JoeyGaspard
Board Regular
- Joined
- Jul 22, 2019
- Messages
- 147
Hi folks, having another little problem with VBA. I am trying to filter a selection from a worksheet, and delete those rows, my filter is working fine, but its not deleting the rows. Here is the code and a screenshot:
'Clean up GrowthRate
With Sheets("GrowthRate")
.AutoFilterMode = False
With .Range("k2", .Range("k" & Rows.Count).End(xlUp))
.AutoFilter 11, "0"
On Error Resume Next
.Offset(1).SpecialCells(12).EntireRow.Delete
End With
.AutoFilterMode = False
End With
Thanks in advance!
'Clean up GrowthRate
With Sheets("GrowthRate")
.AutoFilterMode = False
With .Range("k2", .Range("k" & Rows.Count).End(xlUp))
.AutoFilter 11, "0"
On Error Resume Next
.Offset(1).SpecialCells(12).EntireRow.Delete
End With
.AutoFilterMode = False
End With
Thanks in advance!