Cells find in a row using vba

[Diogomg]

Hi,

I need to find a cell based on another cell row.

I tried to use this but it's not working.

Set aCell5 = aCell.Offset(2, 0).Select
Set aCell3 = aCell5.Row.Find(What:=Range("bb2"), After:=ActiveCell, LookIn:=xlValues, LookAt:=
xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, SearchFormat:=False)

This is just one part of my macro.

Thank You.

 

[Warship]

maybe...

Set aCell5 = aCell.Offset(2, 0).Select
Set aCell3 = Rows(aCell5.Row).Find(What:=Range("bb2"), After:=ActiveCell, LookIn:=xlValues, LookAt:= _
 xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
 , SearchFormat:=False)

 

[Diogomg]

maybe...

Set aCell5 = aCell.Offset(2, 0).Select
Set aCell3 = Rows(aCell5.Row).Find(What:=Range("bb2"), After:=ActiveCell, LookIn:=xlValues, LookAt:= _
 xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
 , SearchFormat:=False)

It worked

Thank You.