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. 


'Set start time for formatting
    Start = Timer

'Formatting code here

'Clock formatting time
    Finish = Timer
    FormatTime = Finish - Start

'Display clock times
     Sheets.Add.Name = "Bin Time"
     Range("a1").Select
     Selection.Value = "Check Form"
     Selection.Offset(0, 1).Value = "Create New Worksheet"
     Selection.Offset(0, 2).Value = "Write Results"
     Selection.Offset(0, 3).Value = "Format Worksheet"
     Selection.Offset(1, 0).Value = FormTime
     Selection.Offset(1, 1).Value = NewTime
     Selection.Offset(1, 2).Value = WriteTime
     Selection.Offset(1, 3).Value = FormatTime