View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
J.Smith J.Smith is offline
external usenet poster
 
Posts: 3
Default 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!