Pages

Cell address of a cell having a specific data

MsgBox Cells.Find(What:="Deposit", After:=ActiveCell, LookIn:=xlValues, LookAt:= _
    xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
    , SearchFormat:=False).Address