Automating Excel Cell Drag and Drop

[Bill Garcia]

Hi;

I've been trying to use Excel's events (Selection_Change
for example) in an effort to automate drag and drop
functionality.

If there is a way of doing this I have not been able to
identify the correct process. Is it possible to do this?
Has any one out there been able to accomplish this.

Appreciate a note either way. Thanks in advance for any
feedback.

Bill

 

[Greg Wilson]

As far as I'm aware, drag and drop only effects a cut and
paste operation. The following achieves the same as drag
and drop absent the screen animation. However, I'm sure
you know how to code this already.

Sub Macro1()
Range("A1:C2").Cut Destination:=Range("C4:E5")
End Sub

Is not cut and paste sufficient or am I missing
something?

Regards,
Greg