Deleting Rows based on Column Critieria
 

I have about 10,000 rows. I want to use a function or macro to delete
rows based on column criteria quickly.

For example, if Columns F-P are blank, I want to delete that row from
the worksheet.

I'm not sure the best way to go about this. I was thinking a macro,
but it always seems that there is function I've never heard of that
works much better. Thank you in advance for your help :)

Deleting Rows based on Column Critieria
 

You must loop or if you add a helper column with a formula that count the cells with data
in column F:P you can filter.

For example code see
http://www.rondebruin.nl/delete.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"blackmanofsteel40" wrote in message oups.com...
I have about 10,000 rows. I want to use a function or macro to delete
rows based on column criteria quickly.

For example, if Columns F-P are blank, I want to delete that row from
the worksheet.

I'm not sure the best way to go about this. I was thinking a macro,
but it always seems that there is function I've never heard of that
works much better. Thank you in advance for your help :)