Are the columns  with 170s always going to be the same columns?
or can they be different columns whereupon you would want the macro
to seek out those columns which have nothing but 170s in them and
then delete only those columns? The latter is a bit harder to write.