Find slowing down

When I first open excel and run my sub everything works fine. The sub looks at a value on one sheet, finds it in another sheet, copies that row and pastes it into another sheet. On first run it is extremely fast. I can run them back to back as many times as I want and it works perfectly. However, if I run it and then wait half an hour to run it again it drags. Instead of finding 20 per second it might find one.

Has anyone else experienced anything like this? It seems like a memory leak but I can't comprehend how VBA would be cause that. Thanks for any help.

Please Login or Register  to view this content.

Why do you need to "see" it work?

Originally Posted by 111StepsAhead

Why do you need to "see" it work?

Yeah, I guess that would help :S I'll have to format the sheet to work without the rest of the code. I'll post it as soon as I can.

I'm not sure if you understand what that line is doing.

Please Login or Register  to view this content.

simply waits until the macro is done running before updating everything when False. If True you are updating the screen after each step which takes significantly more time. It doesn't fully explain why the macro is slowing down after 20 minutes of opening but the difference in speed that you will see should still be a lot.

Originally Posted by 111StepsAhead

I'm not sure if you understand what that line is doing.

Please Login or Register  to view this content.

simply waits until the macro is done running before updating everything when False. If True you are updating the screen after each step which takes significantly more time. It doesn't fully explain why the macro is slowing down after 20 minutes of opening but the difference in speed that you will see should still be a lot.

Yeah, I have that on because when ScreenUpdating is off I can't see how fast the script is running. So if it is doing it's going super slow thing I can't tell.

Post a sample workbook with sample data if you don't mind. It's probably not a memory leak but probably is a looping issue.