Speed Issues again

  • Thread starter Thread starter Jase
  • Start date Start date
J

Jase

Hi All

Sorry to bother you all again, but I have rolled my
project back to an earlier version and stated adding
individual bits of code until I find the great speed
offender. And it seems to me that there is a massive
problem with speed when I start to hide some columns.

Has anyone else had this problem and is there a way around
it? As in when I have hidden columns in the worksheets
the execution speed of the project halves at least. So I
could just unhide all columns whever I perform any
operation but this really isn't the best fix I was hoping
someone would have already jumpted this problem in their
travels

Thanks again
Jase
 
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
 
Back
Top