that's what i was afriad... thanks I'll keep doing my cut/insert...
--
Thank you...


"Mike H" wrote:

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