Column Re-order

Digicelt

New Member
Joined
Dec 22, 2005
Messages
29
Hi, Newbie question here ....

Is there an elegant way in VBA to reorder columns in excel, without doing the long and laborious way :eek: ... copying, inserting, and deleting ?

Thanks, Steve
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Digicelt

New Member
Joined
Dec 22, 2005
Messages
29
Nooooo .. i mean re-order columns ... eg, take column C, put it where A is, move B to D, etc ....
 

daniels012

Well-known Member
Joined
Jan 13, 2005
Messages
5,219
The only way to incorporate VBA would be to have something in each colum for it to evaluate to sort in a certain order. You can however, with a mouse take the bottom edge of a column and drag it to a new spot.

Michael
 

Watch MrExcel Video

Forum statistics

Threads
1,118,032
Messages
5,569,767
Members
412,291
Latest member
marypolitan
Top