View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
blackmanofsteel40 blackmanofsteel40 is offline
external usenet poster
 
Posts: 3
Default 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 :)