Iteration performance issue
vArr = Worksheets("fred").Range("A3:L50")
Worksheets("fred").Range("A3:L50").Offset(3, 20) = vArr
Oh, THAT's how you get a range into/out of an array? Great!
Didn't know that.
application.calculation=xlAutomatic
Wasn't aware of that, either.
I will definitely try these two methods to speed up the code.
(Screenupdating has already been taken care of).
Thanks a lot, Charles!
|