Excel 2003 Macro taking long time in Excel 2007

[Satish]

I have beeen using a Excel 2003 macro which takes few seconds to run where as
the same macro takes 20 mins to run in 2007. Any specific reason to this? any
fixes?

Thanks in advance

 

[Jarek Kujawa]

would you let us have a look at the code?

 

[Jim]

Re-writing the orginal macro into the 2007 to begin with might sort this
issue as I found that if I just copied and pasted the original macro into
2007 from 2003 it came up against this problem but when i re did it, figure
for figure, it seemed to work then. Alas i have no idea why, sorry.

 

[Gord Dibben]

Does your code include checking all cells on a sheet?

Excel 2007 sheet has over 1000 times as many cells as Excel 2003.

As Jarek replied..........post your code.


Gord Dibben MS Excel MVP