Find Last Occurence in a Range with VBA
 

I am using find to get the first address of occurences in a row, but
how do you get the last occurence?

Thanks,
Jay

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

Find Last Occurence in a Range with VBA
 

On Sep 30, 5:17*pm, "Bernie Deitrick" <deitbe @ consumer dot org
wrote:
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- Hide quoted text -

- Show quoted text -

This was not what I was thinking but this will do nicely.
Thanks,
Jay