Hi,
there's no slick method other then cutting. have a look here
http://www.mvps.org/dmcritchie/excel/swap.htm
Mike
"EXCELMACROS" wrote:
Hi..., I want to move the order of my columns, do you know a more efficient
way besides doing:
Cells.Find(What:="abc").EntireColumn.Cut
Range("A1").Offset(0, 8).EntireColumn.Insert Shift:=xlToRight
probably something like moving column 6 before 3...
thanks,
--
Thank you...