Hi

I want to delete rows.
I am doing Vlook up, and I am getting some rows with #N/A and some with 1.
Then I want the code to find out which rows have #N/A and delete them.
I am getting some problems with #N/A, is there any way to convert it to
other thing or in delete rows code, just to put N/A (without #)

Thanks