HELP Make Search In Excel In VBA

How can i search though a set of records on a excel sheet, i was wondering

use

VB Code:

intRow = Sheet1.Range("B8", "B45").Find("Some Text").Row

where sheet1 is the name of the sheet

B8 / B45 specify the range of cells which u want to search. Her i'm searching all the cells in the range B8 to B45. U can change this according to ur requirements

Replace the Some Text with the text u want to search.


This staement will return the row number and hence i'm using a integer varible intRow for the purpose