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

On Fri, 18 Jul 2003 09:11:41 -0700, "John A Grandy"
wrote:

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

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


"Gord Dibben" wrote in message
...
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

On Fri, 18 Jul 2003 09:11:41 -0700, "John A Grandy"

wrote:

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

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



On Fri, 18 Jul 2003 11:29:39 -0700, "John A Grandy"
wrote:

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


"Gord Dibben" wrote in message
.. .
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

On Fri, 18 Jul 2003 09:11:41 -0700, "John A Grandy"

wrote:

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