| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MACRO TO DELETE ROW IF CELL VALUE IS ZERO
I need macro which should go through in column "E2:E" of sheet
("DATA") and if finds any cell value = 0 then it should delete that entire row. Note that I have heading in cell "E1" |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
MACRO TO DELETE ROW IF CELL VALUE IS ZERO
Somthing Like
Sub DeleteZero() Worksheets("Data").Activate Range("E2").Select Do If ActiveCell.Value = "0" Then ActiveCell.EntireRow.Delete Shift:=xlShiftUp ElseIf ActiveCell.Value < "0" Then ActiveCell.Offset(1, 0).Select End If Loop End Sub "K" wrote: I need macro which should go through in column "E2:E" of sheet ("DATA") and if finds any cell value = 0 then it should delete that entire row. Note that I have heading in cell "E1" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Delete cell if value | Excel Worksheet Functions | |||
| How do I creat a macro to delete the first 20 cell characters | Excel Worksheet Functions | |||
| macro - delete row if cell contains string | Excel Programming | |||
| create macro - if cell is 0 delete row | Excel Worksheet Functions | |||
| Delete Row Macro - if cell $5000 | Excel Worksheet Functions | |||
![K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
