Is it possible to create a "For Each" loop that can copy two columns
sequentially one after the other, and after each copy, call a macro,
then copy the results given from the macro into different cells after
each iteration ?
To let you know, my columns contain cutting lists, which I have to
copy to a cell location, then call a "bin-packing algorithm" for each
cutting list. Then the result of each iteration must be saved to
separate cell locations.
I want to be able to run this "loop" based on the number of pairs of
columns with data in them which I have to copy(as the number of pairs
of columns will change all the time).
Any info/pointers you could give me would be of great assistance to
me.
Thank you.
