View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
EXCELMACROS EXCELMACROS is offline
external usenet poster
 
Posts: 43
Default Moving columns order

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