| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
For Each Loop
Helo, can anyone help with this query:
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. -- jj |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DO LOOP in VBA | Excel Discussion (Misc queries) | |||
| How would I add a loop for this? | Excel Discussion (Misc queries) | |||
| vba loop | Excel Discussion (Misc queries) | |||
| Do Loop | Excel Worksheet Functions | |||
| Which loop to use | Excel Discussion (Misc queries) | |||
Threaded Mode
