Code to determine how long it took to run VBA

**Sgligori** · 08-15-2016, 11:15 AM

Hi All,

I'm in need of a code that will time how long it takes to run my entire code.

I expect the code to run for at least 15 hours, so I have to be careful that it doesn't reset at midnight. Any help much appreciated!

**joeu2004** · 08-15-2016, 11:47 AM

[.... deleted by me; got a little carried away ....]

**joeu2004** · 08-15-2016, 08:10 PM

[.... deleted by me; got a little carried away ....]

**sanram** · 08-15-2016, 08:25 PM

One easiest way to do this is as below:

Please Login or Register  to view this content.

Code to determine how long it took to run VBA

LinkBack

Thread Tools

Rate This Thread

Display

Code to determine how long it took to run VBA

Re: Code to determine how long it took to run VBA

Re: Code to determine how long it took to run VBA

Re: Code to determine how long it took to run VBA

Thread Information

Users Browsing this Thread

Similar Threads

Turning old and long code in to a short code

[SOLVED] Represent (define?) a section of code with a variable (shorten long code lines)?

[SOLVED] =IF and =SUMIF formulas creating long long long data processing times.

[SOLVED] Like some ideas on improving code on long IF statement used in VBA code please

Saving a sheet with code as a .prn, but the lines of code are too long?

[SOLVED] To improve Efficiency of code, code running too long

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions