Delete rows

[Guest]

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

 

[Bob Phillips]

=IF(ISNA(vlookup_formula),"N/A",vlookup_formula)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Thanks Bob,

How do I create the delete-rows code and insert what you wrote down for me

 

[Bob Phillips]

If its a once-off, just filter on value N/A, and delete the visible rows.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)