View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben[_3_] Gord Dibben[_3_] is offline
external usenet poster
 
Posts: 51
Default column drag-and-drop

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