Thread: XL 2007 - grinding down to a halt after many rows - no objects,shapes or pagesetups
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
IndigoDingo IndigoDingo is offline
external usenet poster
  
Posts: 3
Default XL 2007 - grinding down to a halt after many rows - no objects,shapes or pagesetups
D'oh!

I had a 'DoEvents' command in the loop. Commenting it out (disabling
my progress bar) reduced the runtime from over 30 minutes to under 30
seconds, without molasses in the resulting sheet.

Thanks anyway Tim. You got me interested in Dictionaries at least. : )

not-so-Indigo
Reply With QuoteReply With Quote