-
Solved: macro slows down each time
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
-
philfer,
Please post your code using code tags.
Have a great day,
Stan
-
the code is about 28 pages long when I print it out!!
-
Put it in a text file and attach that.
-
Q: do you restart Excel or the computer at the end of the day, and it starts out fresh?
Paul
-
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.
-
Thanks Mike
"Offending" posts deleted.
Regards
MD
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules