Slow Code, Please help !

[Tridiro]

Hello Everyone, I need some pointers on tracking down some slow code. Is there a method to see which line of code is causing my module to run really slow. Very thing was find and it was performing perfect, then suddenly it went from 1 second to run the code to 15 seconds. I have found that its considerable slower when I'm filtering data. its also inputting data into hidden cells. is there any known issues or causes when filtering data ?

 

[bfarley4]

When I notice my code is running slower then I like - I usually put in a couple of Msgbox lines denoting it has passed a certain spot in the code until I identify the item in question. If you want more specific insight - you might want to paste in your code.

Have you turned off the screen updates (just remember to turn them back on as it make Excel unstable).

 

[Hooi]

Hello Everyone, I need some pointers on tracking down some slow code. Is there a method to see which line of code is causing my module to run really slow. Very thing was find and it was performing perfect, then suddenly it went from 1 second to run the code to 15 seconds. I have found that its considerable slower when I'm filtering data. its also inputting data into hidden cells. is there any known issues or causes when filtering data ?

You may open the macro and pressing F8 to try line by line

 

[Tridiro]

thanks, the msgbox is a good idea. not sure how to run it line by line

 

[hiker95]

Tridiro,

Can you post your macro code?


At the beginning of your posted code, enter the following without the quote marks:
["code"]


'Your code goes here.


At the end of your posted code, enter the following without the quote marks:
["/code"]

 

[Fazza]

You might find a clean up of the code helpful. Either via a custom add-in http://www.appspro.com/Utilities/CodeCleaner.htm or manually by saving code from each module to notepad and then re-importing. Then compile. Close Excel & open it again, without opening the VBE. [Once the VBE is opened, code will be slower.]