New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Detecting sign changes in Excel

Macros, VBA, Excel Automation, etc.

Detecting sign changes in Excel

Postby NDM » Sun Feb 21, 2016 6:05 pm

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
  • 0

NDM
Rookie
 
Posts: 1
Joined: Feb 21, 2016
Reputation: 0
Excel Version: 2013

Return to Macros and VBA Questions

Who is online

Users browsing this forum: Google [Bot] and 67 guests

cron