Find Last Occurence in a Range with VBA
Jay,
Dim myC As Range
Set myC = Range("A2:A100").Find("Jay", , , , , xlPrevious)
MsgBox myC.Address
HTH,
Bernie
MS Excel MVP
"jlclyde" wrote in message
...
I am using find to get the first address of occurences in a row, but
how do you get the last occurence?
Thanks,
Jay
|