How can you find multiple match in a cell and select the one with the latest date attribute to it

[Jimmy509]

Hello my fellow excel-ers,
I am trying to find search through a range of cells in column A from my excel spreadsheet. I know that I can use .Find to find the first match in that range or use .FindNext to find all of them. But my issue is I would like to find the match for my latest transaction. In Column B I have a range of dates for each transaction.
The transaction ID repeat multiple times for different date. I would to select the date that is the most recent.
I am new to excel VBA. Can anyone help me please.

 

[Jimmy509]

Some adjustments:
Change the datatype of dtMax to Variant

Immediately after the For each rCell in Range("D2:D4") insert this line
dtMax = "Not Found"

In the first Find insert this parameter
LookAt:=xlWhole


M.

ThAnks a lot. I’m getting through it but I reach an error when I tried to set my last cell. Because I am not using a specific range. I am using
with sheet.cells
“ get last cell “
End with