Thread
:
Find method
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Find method
If you only need to find the first instance then this will work.
Sub find2()
MsgBox Columns(1).Find(2, lookat:=xlWhole).Row
End Sub
--
Don Guillett
SalesAid Software
"nk" wrote in message
m...
Is this posible to get a row number(when the value 2 was find) with a
Find metod in code:
With Worksheets(1).Range("a1:a500")
Set c = .Find(2, lookin:=xlValues)
If Not c Is Nothing Then
firstAddress = c.Address
Do
c.Value = 5
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address < firstAddress
End If
End With
Thanks'
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]