Tom,

I see the logic of what you are suggesting.

The cells.count is usually much less than 65536 and is variable. But I
can get the cell count I need.

How do I distinguish between a move and say a delete? If the user
selects an entire column and hits delete, I want to be able to prevent
that. I want to allow only a move. Any ideas on how to trap the key
pressed or something like that I can use to judge user intention before
I exit sub?

Thanks for your response.

Sai