Finding Cell that changes from a Positive to a Negitive number

[tpeter]

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.

 

[CLR]

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

 

[Ron Rosenfeld]

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