Posts by ltj22

Thanks

Hi everyone-I need some help on a catalog I am putting together in Excel. Here's the problem.

I have a spreadsheet with products and their specifications. In the last column of this spreadsheet, there is either a part # or #N/A.

What I would like to do is create a macro that will completely delete every line that has an #N/A in the last column.

I cannot just sort the spreadsheet by the last column because it would change the order of the products.

I'm sure there is a really simple answer to this that I am completely overlooking. Any ideas?