View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KD[_3_] KD[_3_] is offline
external usenet poster
 
Posts: 15
Default Macro speeds in 95 vs 98 vs 2000

Can anyone help ?

We have a macro that amongst other things formats cells
which runs using excel 95 - however when we run this
macro using excel 98 or higher we have noticed a
considerable increase in the length of time taken to
complete the run. Is this due to the vast increase in
the number of cells it might have to format in the later
versions of excel or is it a change in the vba itself?

Many thanks
KD