View Single Post
  #1   Report Post  
Macro to hide rows in spreadwsheet
 
Posts: n/a
Default hide rows with macro

i want a looping macro that evaluates two columns in each row of the
spreadsheet and if both cell contain zeros hide the row. Basically if col b
or col c is zero hide row otherwise don't hdie and move down one row to
evaluate it,