Re: FIND in only one column

Can you post the actual code you tried and define "does not seem to
work". Did you get an error or was it just not found?

You could try adapting the example from Help.

With Worksheets(1).Range("a:a")
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

Tim


"R.VENKATARAMAN" <vram26@vsnl$$$.net> wrote in message
news:%23FRbehSfFHA.3692@xxxxxxxxxxxxxxxxxxxxxxx
>a particular text occurs in many columns.
> But I would like to find that only in one coumn for e.g. column A
> only and
> select that cell
> (in vba programme)
>
> i tried to use
> with columns("a:a")
>
> it does not seem to work
>
> I tried searching in newsgorups and I did not get an appropirate
> thread.
>
> request for suggestions. thanks regards.
>
>


.