View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AG[_3_] AG[_3_] is offline
external usenet poster
 
Posts: 50
Default Reorder the columns in Excel

Hi Everyone,

Does anyone know a way to reorder the columns in the Excel spreadsheet
using a macro. The macro that I have written uses cut, and paste at
the appropriate location. But I need to do this many many times before
I get all the columns in order. I am sure there is a better or shorter
way for this. If anyone has any suggestions, please let me know.
Thanks.

-AG