Hutch,

Your macro works great but with one problem. There are other cells in
the same column as B1. When B1's contents delete, the cells beneath
B1 change position. For example, B10 repositions to become B9, and
then B8 with the next change to the contents of A1. They continue to
migrate one row at a time. Do you have a further suggestion? Thanks.

Michael