Finding dynamic range

maybe so

Sub ert()
Dim rng As Range
Set rng = ActiveSheet.UsedRange.Find("securityId", lookat:=xlWhole)
If Not rng Is Nothing Then
    rng.CurrentRegion.Select
    MsgBox rng.CurrentRegion.Address
Else
    MsgBox "Not found securityId"
End If
End Sub