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

would you let us have a look at the code?

On 3 Lis, 11:45, Satish wrote:
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.
--
Jim


"Satish" wrote:

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

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

On Tue, 3 Nov 2009 02:45:02 -0800, Satish
wrote:

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