If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, and
assuming your data is in a range named "dataRange", the following, array
entered into a vertical range sufficiently large to accommodate the
occurrences of "PORK", will return a vertical column of the cell
addresses of all occurrences:

=ArrayMatch("PORK",dataRange,"A")

Alan Beban

ksnapp < wrote:
I need a sub that searches a column and finds the first cell that says
"PORK", then it has to search fruther down and find the second instance
of "PORK" and give some form of cell refrence/ range reference that I
can plug into a furmula. (I can write that part, I hope). Then I need
it to do the same thing for each successive instance of "PORK." Each
time it says pork im gonna run different formulas in 3 or 4 cells to
the right using the range that the sub returns.

Is this possible?


---
Message posted from http://www.ExcelForum.com/