Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35
Default 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
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
keep cell style in place after drag and drop BDFC Excel Discussion (Misc queries) 0 August 12th 09 03:08 PM
Cell drag and drop clara Excel Discussion (Misc queries) 4 June 18th 08 07:36 PM
how do I drag & drop cell text only Kirstie New Users to Excel 2 May 11th 06 03:01 AM
How do I set cell drag and drop to be on as a default Dick Morgan Excel Discussion (Misc queries) 3 December 5th 05 03:06 PM
cell drop and drag D Snider Excel Worksheet Functions 1 May 1st 05 04:27 AM


All times are GMT +1. The time now is 03:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"