Timing Macro but displaying Macro name

Good morning,

I need to run multiples macros but i need to know how long each macro take to run.

With in my code I'm using some macro lines it display the time but no the Name

This is what i'm using

Please Login or Register  to view this content.

It would be nice if someone help me..


Appreciated

Not tested but you may want to try the codes listed here

Maybe:

Please Login or Register  to view this content.

you would need to access the VBE object model which may or may not be allowed in your environment.

something like:

Please Login or Register  to view this content.

The above would return module name. You would then have to see if you can get the sub name from there.

The option under Macro Security | Trust Access to the VBA project object model would need to be checked for something like that to work.

If you google what you are asking for most techniques seem to rely on error handling and/or static wording to output the subroutine name.

I missed a double quote:

Please Login or Register  to view this content.