Automating Excel Cell Drag and Drop

  • Thread starter Thread starter Bill Garcia
  • Start date Start date
B

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
 
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
 
Back
Top