Find value in a cell

[neepshed]

I need to search a cell for a particular value and based on whether the value is present I need to perform an action.

What is the best way of searching a cell for a determined value.

This search will be done row by row in the spreadsheet. So I dont want to specify the entire spreadsheet range.

Thanks.

 

[jfdabiri]

Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True 'if you want to see the app?
Set objWorkbook = objExcel.Workbooks.Add()
Set objWorksheet = objWorkbook.Worksheets(1)

objExcel.Cells(1, 1).Value = "A"
for i = 1 to some_nbr ' nbr of rows?
for j = 1 to some_other_nbr ' nbr of columns?
if objExcel.Cells(i,j) = "something" then
MsgBox "found the value"
end if
next
next