| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find first occurence of a number in an array 7 cols wide | Excel Worksheet Functions | |||
| Trying to FIND lowercase or uppercase of target occurence | Excel Worksheet Functions | |||
| Find first occurence in a list that's greater than a specific num | Excel Worksheet Functions | |||
| Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
| I need to count the occurence of text in a range of cells (which . | Excel Worksheet Functions | |||
Linear Mode
