I am doing an iterative hide of columns that of all but ones which meet the
day of the week criteria. The macro ran fine for years through the upgrade
from 2003 to office 2007.

I have just upgraded my machine to a more powerful machine and my macro now
takes has increased processing time by 50 to 60 times for this iterative hide.

I have noticed that machines that went through the office 2003 installation
prior to 2007 still run it fine.

Example dell latitude d620 that never had 2003 takes 2 to 3 minutes to
complete. same type of laptop that did go through the path takes
approximately 2 seconds on a slow day.

finally my dual core optiplex 760 with 3 gig or ram takes several minutes.

outside of installing office 2003 on dozens of machines and then upgrading
to 2007 is there a solution?

One thing I'd check (and maybe the experts can chime in on whether this
actually affects processing time to the extent you are describing); on your
upgraded machine, is XL07 running in "compatibility mode"? Create a new
worksheet on both machines, and scroll to the right to see the last column.
If it is IV on the upgraded machine, but in the triple digits for the regular
2007 machines, that might be part of the problem depending on how you set up
your code (e.g. does it check columns 1-100 or does it check "each column in
columns").

Either way, Barb's suggestion is a good one. Also, do you turn of
calculation and screenupdating at the top of your code block, and turn them
back on at the bottom?

HTH,
Keith


"Epidemic" wrote:

I am doing an iterative hide of columns that of all but ones which meet the
day of the week criteria. The macro ran fine for years through the upgrade
from 2003 to office 2007.

I have just upgraded my machine to a more powerful machine and my macro now
takes has increased processing time by 50 to 60 times for this iterative hide.

I have noticed that machines that went through the office 2003 installation
prior to 2007 still run it fine.

Example dell latitude d620 that never had 2003 takes 2 to 3 minutes to
complete. same type of laptop that did go through the path takes
approximately 2 seconds on a slow day.

finally my dual core optiplex 760 with 3 gig or ram takes several minutes.

outside of installing office 2003 on dozens of machines and then upgrading
to 2007 is there a solution?