Column Re-order

[Digicelt]

Hi, Newbie question here ....

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

Thanks, Steve

 

[daniels012]

Do you mean sort Columns??
Michael

 

[Digicelt]

Nooooo .. i mean re-order columns ... eg, take column C, put it where A is, move B to D, etc ....

 

[daniels012]

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