View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ksnapp[_36_] ksnapp[_36_] is offline
external usenet poster
 
Posts: 1
Default Returning Cell Refrences/range Refrences

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

Is this possible

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