Testing the speed of sections of VBA code?

[GBagley]

Anyone have a great way of testing the speed of certain sections of VBA code? I have a program that takes some time and goes through a ton of loops. I'm interesting in testing each section of the code to see which parts take the longest to run through. Which lines/formulas take the longest. For example, if my code takes 30 minutes to run in full, and one particular section accounts for 90% of that time, then I would want to focus in on improving just that part. I know I could have the code print times after every line, but it's already a lengthy macro as is, and it seems like there must be a better way to do a speed analysis?

 

[Norie]

Are you sure testing individual sections of the code will help you identify what's slowing things down?

One thing I'm wondering about is Application.ScreenUpdating and userforms.

Perhaps somehow, and I don't actually know if it's possible, showing userforms is 'interfering' with you turning off screen updating?

 

[Zack Barresse]

If you do not want to post your code, and it does sound large, maybe at the least describe what your code is doing, as well as its original intent and scope.