vikas_newports
Board Regular
- Joined
- May 26, 2016
- Messages
- 121
- Office Version
- 365
- Platform
- Windows
Hello
I want to Delete the rows have #N/A after apply the ilter and criteria1 #N/A but it delete the one record without #N/A
here is my code
I want to Delete the rows have #N/A after apply the ilter and criteria1 #N/A but it delete the one record without #N/A
here is my code
VBA Code:
Set rng4 = Range("B5:N" & last_row4)
With rng4
.AutoFilter
.AutoFilter Field:=13, Criteria1:="#N/A"
On Error Resume Next
.SpecialCells(xlCellTypeVisible).EntireRow.Delete
On Error GoTo 0
.AutoFilter
End With