column drag-and-drop

J

John A Grandy

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

Gord Dibben

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
 
J

John A Grandy

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 ...
 
G

Gord Dibben

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
 

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

Drag and Drop does not work Outlook for Mac 0
How to make repeating drop-down lists? 2
MS Project Center-Autolink column fields 0
Merging from an Excel file with graphics 1
Drop down lists in seperate columns 5
Copy addition formula of non-consecutive horizontal cells 2
Link a text box based on drop down box with four options MS Word 365 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0

Top