A function to find a phrase within a range of cells and return the
Thanks for the quick reply. I managed to hash the following together
which works admirably:
Function FindInRange(Range As Range, What2Find As String) As String
' Finds What2Find in Range and returns address of first instance
FindInRange = Range.Find(What:=What2Find,
after:=Range(Range.Count)).Address
End Function
I can't believe it took me so long!
|