View Single Post
  #33   Report Post  
Posted to microsoft.public.excel.programming
Howard Kaikow Howard Kaikow is offline
external usenet poster
 
Posts: 269
Default RowHeight and AutoFit wit Merged Cells

I added timing to the inner guts of the program
Witrh Screenupdating disabled, time was 3943 milliseconds.
With Screenupdating enabled, time was 4833 milliseconds, that's one heck of
a
relative performance hit!

Both of the above were run from the VBIDE.

I compiled the VB 6 code, time to run was 3924 millisconds.

Excel is not visible in all cases.

Perhaps a silly question, but is there "documentation" of how a disabled
Screenupdating affects non-visible documents?

Oh well, a few daze ago the code was taking over 50 seconds.