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.
OP states "..pull in *data* from multiple sources" which suggests that
there are no formulas!
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion