harsha547
6/8/2017 - 4:13 PM

VBA Tricks _ Find

Sub findd()

Dim rg As Range

Set rg = Range("E:E").Find("Bulgaria")

Debug.print rg.offset(0,1)

End Sub