Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete records when certain records have duplicate column data | New Users to Excel | |||
show number of selected records in Excel | Excel Discussion (Misc queries) | |||
Trouble identifying selected records | Excel Discussion (Misc queries) | |||
Summing user selected records | Excel Programming | |||
How can I ensure #records in a selected set always shows in Excel | Excel Discussion (Misc queries) |