Multi-conditional Do While loop in conjunction with a multi-conditional Do Until Loop

hmmmmmmm....the description is tough to follow, really. here's what I personally see as your wish:

- you want to run 2 loops.
- you want to check if 1 cells is less than / greater than another in every iteration of the loop.
- you want 2 types of loops - DO WHILE and DO UNTIL.

that right? if so, you can make it much simpler than that. furthermore, there is no return statement in this language. that is for more advance langs like web languages. functions can return, subs cannot. but ""return"" is not used. a simple assignment to the function's name via an equals (=) sign is.

regarding Dx and Cy, not really sure what you're talking about there. got details?

Originally Posted by vba_php

hmmmmmmm....the description is tough to follow, really. here's what I personally see as your wish:

- you want to run 2 loops.
- you want to check if 1 cells is less than / greater than another in every iteration of the loop.
- you want 2 types of loops - DO WHILE and DO UNTIL.

that right? if so, you can make it much simpler than that. furthermore, there is no return statement in this language. that is for more advance langs like web languages. functions can return, subs cannot. but ""return"" is not used. a simple assignment to the function's name via an equals (=) sign is.

regarding Dx and Cy, not really sure what you're talking about there. got details?

Yes, I want to run two loops, but I'm wanting to treat the "Do While" Loop as the beginning of a trend. The "Do Until" loop will be treated as the end of a trend. I understand it's a bit difficult to follow. Currently on my personal laptop and don't have my access to my spreadsheets.