I am looking for a function that will look threw either columes or rows and
find the cell that changes from a positive number to a negitive number. This
location will always change and once this cell is found I need to used it in
a function to check for linearity. I have looked thew the help and forum and
haven't really found anything that might work. Any help with possible
functions would be great.

Without looking at it too deeply, some thoughts come to mind.
1-What causes "the" cell to change from positive to negative?
2-Can more than one cell change at a time?
3-Will more than one cell ever be negative?
4-What is the approximate maximum size of the range of interest?

Vaya con Dios,
Chuck, CABGx3



"tpeter" wrote:

I am looking for a function that will look threw either columes or rows and
find the cell that changes from a positive number to a negitive number. This
location will always change and once this cell is found I need to used it in
a function to check for linearity. I have looked thew the help and forum and
haven't really found anything that might work. Any help with possible
functions would be great.

On Wed, 12 Dec 2007 09:31:01 -0800, tpeter
wrote:

I am looking for a function that will look threw either columes or rows and
find the cell that changes from a positive number to a negitive number. This
location will always change and once this cell is found I need to used it in
a function to check for linearity. I have looked thew the help and forum and
haven't really found anything that might work. Any help with possible
functions would be great.

Will the range always start with a positive value? Or might it start negative,
go positive and then go negative?
--ron