Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Deleting Rows
For a Macro novice...
Is there an easy macro that deletes rows when a particular cell has the value 0 (zero)? Thank you |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Deleting Rows
try
Sub deletezerorows() Application.DisplayAlerts = False On Error Resume Next vlr = Cells(Rows.Count, "d").End(xlUp).Row With Range(Cells(2, "D"), Cells(vlr, "D")) .AutoFilter Field:=1, Criteria1:="0" ..SpecialCells(xlCellTypeVisible).Delete .AutoFilter End With Application.DisplayAlerts = False End Sub -- Don Guillett SalesAid Software "fak119" wrote in message ... For a Macro novice... Is there an easy macro that deletes rows when a particular cell has the value 0 (zero)? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting All Empty Rows | Excel Discussion (Misc queries) | |||
resetting last cell | Excel Discussion (Misc queries) | |||
stop users from deleting rows | Excel Discussion (Misc queries) | |||
Deleting rows in a macro in Excel | Excel Discussion (Misc queries) | |||
Deleting rows containing common data | Excel Discussion (Misc queries) |