On Cell Drag Event

[Guest]

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

 

[NickHK]

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 Tools>Options,
but you also lose the ability to AutoFill.

NickHK