Speeding Up Code

Hey, you decreased my run time from a number of hours to a number of
seconds. Thanks a bunch! Have a great day!

Looks like all you needed was to turn off calculation.

the other changes are of trivial benefit at best.

Application.Calculation = xlCalculationManual

existing code.

Application.Calculation = xlCalculationAutomatic

--
Regards,
Tom Ogilvy

<robbywvut@hotmail.com> wrote in message
news:1125422598.661888.316840@z14g2000cwz.googlegroups.com...
> Hey, you decreased my run time from a number of hours to a number of
> seconds. Thanks a bunch! Have a great day!
>