Find Last Occurence in a Range with VBA

  • Thread starter Thread starter jlclyde
  • Start date Start date
J

jlclyde

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

Thanks,
Jay
 
Jay,

Dim myC As Range
Set myC = Range("A2:A100").Find("Jay", , , , , xlPrevious)
MsgBox myC.Address

HTH,
Bernie
MS Excel MVP
 
Jay,

Dim myC As Range
Set myC = Range("A2:A100").Find("Jay", , , , , xlPrevious)
MsgBox myC.Address

HTH,
Bernie
MS Excel MVP







- Show quoted text -
Click to expand...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find the last occurance of a character in a cell 5
the Last occurance 3
Excel VBA setting Ranges 2
How to find last match in a column? 5
This has me stumped 4
Select last cell in Selection 4
Lookup the last occurance of a value in a list 6
Countif or sumproduct using a date range and another criteria 4

Back
Top