FIND in only one column
 

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.

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" wrote in message
...
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.

FIND in only one column
 

with columns(1)

should work, too.

"R.VENKATARAMAN" wrote:

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.

--

Dave Peterson