kittronald presented the following explanation :
Garry,
Took a while to get back to this thread.
The macro actually works with smaller data sets.
Apparently, Excel runs out of memory and crashes before the macro
finishes.
Working with a smaller data set appears to fix the problem.
Thanks for getting back to me.
- Ronald K.
Yep! Normally large sets of data are processed in 'blocks' that are
sized to run at decent performance without overloading resources. It's
hard to say what size to use but generally 50% of RAM is a safe number.
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc