(Solved) – Referencing a Cell in FIND in VBA


Is there way in VBA that instead of using “6/15/2020” as the reference, I use a specific cell as a reference. Lets say that I want that specific cell to be A1. I’ve been trying to do it in different ways and I just cant seem to get it to work.

Cells.Find(What:="6/15/2020", After:=ActiveCell, LookIn:=xlFormulas2, _
    LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
    MatchCase:=False, SearchFormat:=False).Activate

Leave a Reply

Your email address will not be published. Required fields are marked *