MrExcel.com - Your One Stop for Excel Tips & Solutions

excel columns

Posted by TomL on July 10, 2001 8:02 AM

can the position of a column in an excel workbook be
changed programaticallyas part of a macro? For example, after the macro does its computations i want column d to be moved to the column b position.

thanks in advance

Posted by Barrie Davidson on July 10, 2001 8:05 AM

Try:
Columns("D:D").Cut
Columns("B:B").Insert Shift:=xlToRight

Regards,
Barrie