find a value and delete that row
This macro is only deleting one row (that has a zero value in H:H range)
from top. I want all the rows that have zero values in H:H range.
"Stefi" wrote:
On Error Resume Next
Columns("H:H").Find(What:=0, After:=[H1], LookIn:=xlValues, LookAt:= _
xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:=False _
, SearchFormat:=False).EntireRow.Delete Shift:=xlUp
On Error GoTo 0
Regards,
Stefi
€˛TUNGANA KURMA RAJU€¯ ezt Ć*rta:
I am looking for a macro for..... Find zero values in range H:H of this
w/sheet and delete those entire rows.If no cell in range H:H has zero value
do nothing.
say if cell H232=0 ,delete row number 232 ,and row 233 to end row will move
up in the w/sheet.
|