Thread: delete row?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vince[_4_] Vince[_4_] is offline
external usenet poster
 
Posts: 1
Default delete row?

need some help on this one.

Is there a way to check to see if there is a value or not null for three
cells in a row and if there is not, then delete the row?

Example:

I have sheets of customer information where each row is a different customer
(name, address, ect..), but if they do not have a contact number (home,
work, cell) i would like to delete them.

I'm pretty sure that this can be done via macro, but don't know how. Any and
all help is greatly appreciated!

Thanks
Vince