cell drag select event

[krish]

Hi,

In Excel 2007, you could drag a cell and copy the value into multiple cells. which event will trigger when the user do a drag from one cell to the destination?. I need to read the value being dragged and the destination cells. The recorded macro shows the following.

Range("H4").Select
Selection.AutoFill Destination:=Range("H4:H9"), Type:=xlFillDefault
Range("H4:H9").Select
Range("H9").Select

 

[Juan Pablo González]

As far as I know, there's no events that will tell you that information.