View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Steve Hieb Steve Hieb is offline
external usenet poster
 
Posts: 27
Default Speed Issues again

Hi Jase,

Seems to me there is something else going on. Contrary to your
findings, I ran some crude tests and found some code ran on average
20% faster with the columns hidden. My tests simply looped thru a
block of numbers (300 rows x 30 columns) setting each cell to its
current value. I ran the test 50 times w/ the columns hidden and 50
times w/ them visible, then compared the averaged of each. On any
single test you might expect results to vary, so I think looking at an
average over several iterations is appropriate. Not sure if you
tested your problem several times or once. Guess it doesn't matter if
your results are substantially different w/ the columns hidden.

Just seems to me like something else is causing the slow down if its
substantially different, which it sounds like it is. Sorry no help.

I'm sure you already know about "Application.ScreenUpdating = False".

Regards,
Steve Hieb