Hi Leo,
In answer to:
Would
Range("p2").Value = temp2 - temp
by any chance be
Range("p2").Value = temp - temp2
Yes sorry that was a typo.
As for your second query, I need to explain that the sequence of numbers
should never increase so I will change the sequence you wrote for one
actually in my data set and the required result
For the numbers:
J2: 1050
M2:Q2 = 700,700,350,350,0
The resulting sequence in M2:Q2 would be
350,0,350,0,350
I thinking that I can use a test for zero to stop the loop.
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!