Allowing Users to Drag and Drop Cells
Overview
You can specify whether the user can select a cell or range of cells and drag and drop them to a new location in the same sheet. When the mouse button is released and the cell block is dropped, the DragDropBlock event occurs (ActiveX controls) or the control sends the SSM_DRAGDROP message (DLL control).
Whether the data in the cells is copied or moved by the drag-and-drop operation is determined by the user's actions as described in Copying Data and Moving Data.