VBA wave plan builder

Maybe :

Please Login or Register  to view this content.

Thanks for marking the thread as solved and rep.points.

In VBA (and other VB families like VB6), we must define each variable name immediately followed by it's type (unlike other programming language like C++ which you can define all the variables at once for one variable type).

So, if you do it like this :

Please Login or Register  to view this content.

it means you define a as variant, b as variant, i as variant, p as variant, w as variant, t as variant, u as variant; only wsize that defined as long.

Ok, I'll try.

>> Get the wavesize

Please Login or Register  to view this content.

>> Get input array a

Please Login or Register  to view this content.

>> Create output array b where the result will be written

Please Login or Register  to view this content.

>> Looping for each row in input array

Please Login or Register  to view this content.

>> w is variable to hold current wave number (as seen on B21:B32) like Wave 1, Wave 2, etc
>> t is variable to hold carried total, for example on D4, the route is 26, so first time t=26
>> after subtracted by wavesize it becomes t=2, after added by D5 (route is 13) it becomes t=15, etc
>> Now on column 2, anytime we get the value of a row is different with the value of row above it,
>> (like Orange vs Blue) we will reset the w to 1 and t to 0

Please Login or Register  to view this content.

>> It is possible that one data row is splitted to several output rows (like D4), so we must
>> process this inside another loop (Do..Loop)

Please Login or Register  to view this content.

>> Write output to Excel range

Please Login or Register  to view this content.