find function

[obener]

hi all,

I have been using the find function to search a specific column and it seems to search the whole lot. Is there a search function that can be used.

at the moment I am using the following statement

Cells.Find(What:=snn, After:=Range("b1"), LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False)


I just want to be able to search for a value in the B column

thanks

 

[VoG]

Try

Columns("B").Find(What:=snn, After:=Range("b1"), LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False)

 

[obener]

Thanks vog for that. I think I was overthinking that moment.