If you record a macro for this action, you will see that it is really a
Cut/Paste.
The apparent movement of the range is not something that is exposed by
Excel.
If it is a problem, you can disable the dragging of cells in ToolsOptions,
but you also lose the ability to AutoFill.

NickHK

"kt" wrote in message
...
We are looking for an on drag event for dragging a cell/range. Is there
one
as there does not seem to be many for a worksheet. If not can one be
created?
If not why is this not exposed by Microsoft as clearly there is an on drag
event on a range.

Thanks in advance