Automating Excel Cell Drag and Drop
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
-----Original Message-----
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
.
|