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 . |
All times are GMT +1. The time now is 02:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com