column drag-and-drop

  • Thread starter Thread starter John A Grandy
  • Start date Start date
J

John A Grandy

i am interested in the various column drag-and-drop solutions people may
have come up with ....
 
John

Select column by clicking on header. Drop cursor to edge of any cell.

Drag to move. Asks to "overwrite" if dropped on any column with data.

SHIFT + Drag to move. Inserts column if dropped on another column with data.

CTRL + Drag to copy column. Will overwrite without warning.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Hi Gord. For my app, I need col moves to trigger additional VBA code .....
that's what I was getting at when I said "drag-and-drop solutions" ....
because I don't see that an Excel Worksheet intrinsically provides events
which could be used to handle this ...
 
OK John

Should have realized since this is a programming group.

Personally too weak in programming to be of any help to you. Certainly one of
the stronger types will drop in.

Gord
 
Back
Top