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

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