Excel 2003 Macro taking long time in Excel 2007

  • Thread starter Thread starter Satish
  • Start date Start date
S

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
 
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.
 
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
 
Back
Top