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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making a matching worksheet allowing drag and drop of protected cells... 2
Excel Drag and Drop 2
Clear a "moving" range offset from Target 31
Drag and drop 2
Fields and custom fields 0
Drag and drop text in userform text / combo boxes 1
Set Column choice to a variable from a Drop Down 4
Drag and Drop in user forms 3

Back
Top