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.
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.