Using a cell reference for find?

[Paul B]

Set rng = Columns(1).Find(What:="Paul")
Using this to find the row with Paul in column 1 works fine , is there
anyway to use a cell reference for this, I need the Find What to look in
cell AF2 can this be done? So if Paul was in AF2 it would still find it in
column 1.
Something like this, but of course this does not work.
Set rng = Columns(1).Find(What:= Range("AF2"))


Thanks Paul B

 

[Bernie Deitrick]

Paul,

You need to use the .Value property:
Set rng = Columns(1).Find(What:=Range("AF2").Value)

HTH,
Bernie
MS Excel MVP

 

[Paul B]

Bernie, thanks
Paul B

Paul,

You need to use the .Value property:
Set rng = Columns(1).Find(What:=Range("AF2").Value)

HTH,
Bernie
MS Excel MVP