HELP

I am helping develop an Excel Add-In and it has become imperative to do some time testing to determine where the program is bottlenecking. I am trying to automate this process as much as possible but I feel that there is a much more efficient way that is out there that Im not thinking of (arrays?).

So far I have timers set through out the program. In an individual procedure, I have four parts where I have saved the process time in the following variables: FormTime, NewTime, WriteTime, and FormatTime

I want to take these times and create a output on a worksheet that gets added to each time I run the test. I am still very new to VBA and would like to know how best to approach this. Below is an example of what I have for one of the processes in the procedure as well as what I have so far to write the output. 


Please Login or Register  to view this content.