How to see Macro running time

[lapot]

Hi all

I have a workbook that runs with so many macros, Sometimes if I request something it takes so long to produce , I just wonder if there is a place on Excel VBA section to see the execution time for each macro or if there a macro to give me each macro's running time?

I like to tackle the macros that takes to long to execute.

Any help will be apricated

Kind regards

[Sintek]

Something like...

Please Login or Register  to view this content.

[torachan]

Attached file is how I check.
The process in the file enabled me to predict if files were going to get unwiedly when containing several years worth of data.
The array is seeded by setting the number of rows of data upto 1million+ (the sort is between two dates and person code).
Purpose is to generate transaction history and import file into Sage50 - I have highlighted the timer code at each end - use similar approach enclosing your macro.
torachan.

[lapot]

thank you for both of your answers but I don't understand how do I use both of these solutions on my workbook.

I have 50 different macros in different Modules , how these will give me a timing report on these macros at one go?

sorry if I am being a bit dumb

[torachan]

did you write the macro's, if so @sintek's code should be self-explanatory - you put the first two lines at the start of your macro and the last line at the end then run the macro as normal and look at the debug print when it has finished, do this with all the macro's and you should then know how long each one actually takes.

[Sintek]

Or something like this to see how long it takes for all...

Please Login or Register  to view this content.

[lapot]

Thank you for this I will try this, I really appreciate

[lapot]

Thank you again, I have tried this code but nothing has happened, if this is going to give me the total of running time it is not what need , I like to see each of these Macros running time

Please Login or Register  to view this content.

[Sintek]

I have tried this code but nothing has happened, if this is going to give me the total of running time it is not what need , I like to see each of these Macros running time

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[lapot]

I see I need to do for each macro

thank you

[Sintek]

Well your words were....

I like to see each of these Macros running time