| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time consumption in macros
Really thanks to all of you. It has been very useful.
"Bob Phillips" wrote: As an example, rough and ready but should suit Dim i As Long, j As Long Dim nTime As Double nTime = Timer For i = 1 To 10000 For j = 1 To 10000 ' Next j Next i MsgBox Timer - nTime -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jon" wrote in message ... Hi eveybody, here I am with one question: How can I know the time which takes to Excel to execute a macro. Because I have got some loops and I want to know how long does it take in order to view if I can improve the loops or not. Probably it is a simple question which I don't know and I think it is very useful. Thanks for your time!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charting time consumption | Excel Discussion (Misc queries) | |||
| What is the formula to calculate electricity consumption | Excel Worksheet Functions | |||
| What is the formula to calculate time & power consumption | Excel Discussion (Misc queries) | |||
| Fule consumption | Excel Discussion (Misc queries) | |||
| Consumption function | Excel Discussion (Misc queries) | |||
Hybrid Mode
