MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Executing time of 'Find'method and looping

Posted by Mindy on May 29, 2001 7:09 AM


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.


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.


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()
MsgBox Format(Now() - time, "hh:mm:ss")
End Sub