View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ryan H Ryan H is offline
external usenet poster
 
Posts: 489
Default 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
.