Delete Selected Records
maybe something like this:
Sub delete_zero()
Dim lRow As Long
For lRow = 100 To 1 Step -1
With ActiveSheet.Cells(lRow, 1)
If .Text = "0" Then .EntireRow.Delete
End With
Next lRow
End Sub
it will loop through the range A1:A100 going bottom to top.
--
Hope that helps.
Vergel Adriano
"Ian B" wrote:
Hi,
How do I delete an entire rows but only when column A = 0
Thanks
Ian
|