Executing time of 'Find'method and looping
Posted by Mindy on May 29, 2001 7:09 AM
Hi
If I have to search the data exists in the worksheet,
shold I use the Find method or looping method?
Which method is faster?
Thank you.
Mindy
Posted by Dave Hawley on May 29, 2001 7:14 AM
Hi Mindy
In my opinion there is no doubt the Find is the quicker and better option.
Dave
OzGrid Business Applications
Posted by Alan on May 29, 2001 8:38 AM
Simple way to check :-
Sub Whatever()
Dim time As Date
time = Now()
'YOUR CODE
MsgBox Format(Now() - time, "hh:mm:ss")
End Sub
