Hi,
I have a sheet where i have data from Column A to E
In column E i have data like mentioned below(example)
E1 4654654
E2 #N/A
E3 6546548
E4 #N/A
E5 5465456
E6 #N/A
E7 465465
E8 5465465
E9 #N/A
E10 5445
I need vba to delete entire row if the cell in column E does not contains #N/A. wants to Keep only those rows which contains #N/A in column E
Bookmarks