P
pgarcia
Is there a code or a way to seclec row to delete with out spisifing the row
range or cell? Please see "<---" below. Thanks
Selection.AutoFilter Field:=9, Criteria1:="="
Range("A42861:I42861").Select <--- It would be for this range of rows
Range("I42861").Activate
Range(Selection, Selection.End(xlDown)).Select
Selection.EntireRow.Delete
Range("I42861").Select
Selection.AutoFilter Field:=9
or
Selection.AutoFilter Field:=9, Criteria1:="="
Rows("2:2").Select <--- or for this range of rows
Range(Selection, Selection.End(xlDown)).Select
Selection.Delete Shift:=xlUp
Selection.AutoFilter Field:=9
Range("A2").Select
range or cell? Please see "<---" below. Thanks
Selection.AutoFilter Field:=9, Criteria1:="="
Range("A42861:I42861").Select <--- It would be for this range of rows
Range("I42861").Activate
Range(Selection, Selection.End(xlDown)).Select
Selection.EntireRow.Delete
Range("I42861").Select
Selection.AutoFilter Field:=9
or
Selection.AutoFilter Field:=9, Criteria1:="="
Rows("2:2").Select <--- or for this range of rows
Range(Selection, Selection.End(xlDown)).Select
Selection.Delete Shift:=xlUp
Selection.AutoFilter Field:=9
Range("A2").Select