Thread: Cell Selection?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
M.A.Tyler
 
Posts: n/a
Default Cell Selection?

I have a colum of 5 numbers. They are from 0 to 198, but in any random order.
My problem is, I need to use the top three ie: A1,A2,A3, unless any of them
are 198, then it would be passed, and I would need to include the forth ie:
A4, and if that were 198, then the fith, A5.

Can someone suggest the best, or any way to do this?

Thanks!