PDA

View Full Version : Solved: macro slows down each time



philfer
02-06-2008, 12:21 PM
Hello,

I have a macro that runs quite quick.

However if I change a small piece of code and run it again it slows down.

If I run it a third time in the day it is slow also.

However if I go home and come back in the next morning it is just as quick as the first time.

Can anyone tell me why this is happening and what I can do to sort it out.

Thanks
Phil

stanleydgrom
02-07-2008, 09:36 PM
philfer,

Please post your code using code tags.


Have a great day,
Stan

philfer
02-10-2008, 06:07 AM
the code is about 28 pages long when I print it out!!

Jan Karel Pieterse
02-11-2008, 12:04 AM
Put it in a text file and attach that.

Paul_Hossler
02-12-2008, 04:55 PM
Q: do you restart Excel or the computer at the end of the day, and it starts out fresh?

Paul

mikerickson
02-12-2008, 06:12 PM
My apologies for any misunderstanding.

I posted a bad suggestion regarding the slow macro, realized how foolish my suggestion was, and edited the post, asking the moderators to delete the post.

Re-reading, I see that is not clear than the "dumb idea" I refered to was my own post. I should have been more specific.

No comment on any one else was intended.

mdmackillop
02-13-2008, 08:11 AM
Thanks Mike
"Offending" posts deleted.
Regards
MD