Jindon: your solution took 40 seconds. that is awesome.


now, I need to understand it.

1) I get the first part With "a range"
2) the second line I don't entirely understand it. I have never used EVALUATE
3) then you cleared any empty cell within the range using specialcells(4).delete

thanks a lot for your solutions guys
-Phil