View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
andresg1975 andresg1975 is offline
external usenet poster
 
Posts: 60
Default create macro that erases rows having blank cells and

let's say i have this:

column O

row 1 750
row 2 0
row 3 blank cell
row 4 ----------
etc

how can i create a macro that looks column O, delete rows that contain 0
values, blank cells, and ---------.

thanks for your help