On Cell Drag Event

[kt]

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

"kt" <kt@discussions.microsoft.com> wrote in message
news:90E01130-F569-4C4F-98B3-A5D5AD04F3BE@microsoft.com...
> 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