Time-Saving Metrics on Sorting By Color
I'm not sure if there has been a study on that or not, but I would suggest if
you can't find anything, use this code below to time it and see for youself.
Sub TimeTest()
Dim StartTime As Single
Dim EndTime As Single
Dim RunTime As Single
StartTime = Timer
' run test sort code or color sort code here
EndTime = Timer
RunTime = EndTime - StartTime
MsgBox "RunTime = " & RunTime
End Sub
Hopefully this helps! If so, click "YES" below, Thanks!
--
Cheers,
Ryan
"Henry Stockbridge" wrote:
Hi,
I am trying to find out whether metrics have been captured related to
the time saved by sorting Excl text or background by color. Has
anyone come across these numbers, and if so, what are they, or where
are they posted?
Thanks,
Henry
.
|