Olly - that works great, but only if there are blank rows to find. - how do you change it so that it doesnt crash if there are NO blank cells?

Nathansav - I get a syntax error on the line
      s=s& c.row & ","