I am very new to the world of macros and would like some help
I would like to write a macros to detect when values in a row changes from positive to negative and back to positive (essentially if you graphed it out it would look like a dip or a peak , depending on the direction of sign change)
The tricky bit is that for each worksheet the number of rows in that column are different so the macros would need to be so that it applies to all rows with a value in it
Hope this makes sense!
any help is much appreciated