Prev: Counting values in an array where value in one column is not null
Next: Help with Date Function
From: Eán on 21 Apr 2010 06:22
Is there a macro of function I can use to find key words or statements on a
worksheet, similat to the Find (goggles) icon?

Many thanks.

From: Jacob Skaria on 21 Apr 2010 07:09
Try the below...If you are looking for a whole cell match; then change LookAt
to xlWhole

Sub Macro()

Dim varFound As Variant, varSearch As Variant

varSearch = InputBox("Find string")
Set varFound = Cells.Find(varSearch, LookIn:=xlValues, LookAt:=xlPart)
If Not varFound Is Nothing Then
varFound.Activate
End If

End Sub


--
Jacob (MVP - Excel)


"Eán" wrote:

> Is there a macro of function I can use to find key words or statements on a
> worksheet, similat to the Find (goggles) icon?
>
> Many thanks.
>
 | 
Pages: 1
Prev: Counting values in an array where value in one column is not null
Next: Help with Date Function