View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Rearranging columns in a large spreadsheet

Hi Frank,

Am Sun, 14 Jun 2015 20:52:14 -0400 schrieb Phrank:

I did today, though, and
this code works brilliantly! The only downside I've found from the
code is that it is fairly slow. The workbook is fairly large, having
62 columns and about 5000 rows. I'm moving around 14 columns, and it
takes roughly 3-4 minutes for the code to execute. Is that normal? Is
there something I might be able to do to speed that up?


do the columns have formulas? Then set Calculation to "Manual" before
running the macro.
If that does not speed up the macro please post the macro with the
modifications you made.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional