Find NOT AVAILABLE value and delete entire row

[augustus88]

Hey folks,

I am pretty sure you guys can handle with the hands down at this one. I would like to search for the column Q and where I find the #N/A, which came from the VLOOKUP, i would like to delete the entire row as I dont need it.

I looked up with the search engine but I could find the answer, I apologise for any inconvenience I might have caused.

Thanks so much.

Cheers.

[nilem]

Hi augustus88,
maybe something like this

Please Login or Register  to view this content.

[augustus88]

Thanks, nilem

How do I used it? By creating a button and linking it to the sub?

Cheers.

[nilem]

Yes, it's a good option.
or press Alt+F8, select the "test" macro and click Run

or you can select your column Q, press F5 - Select - checkmark "Formulas", "Errors" - Ok and press Ctrl+- ("Ctrl" and "-")

[augustus88]

Thanks, bro.

Cheers!