Obtain the start and end times of processes having many variables

Maybe :

Please Login or Register  to view this content.

karedog see this if using collection
how to solve using collection
karedog.png

@Robert :
You are welcome, and don't forget to mark this thread as solved, thanks.

@daboho :
We have told you (rory and I) in this thread :
https://www.excelforum.com/excel-pro...-criteria.html
but you you did not respond.

You have to change VBE Error Trapping Mode, back to default (Break on Unhandled Errors).
On VBA window, select menu Tools -> Option -> Select "General" tab -> change to "Break on Unhandled Errors"

EF1255859.gif

Hi karedog,
Could you help alter the code so that the next Job assigned to each machine must start right after the previous job is ended, unless clean time is needed due to product type change?
Appreciate your help. Sample filt attached.
Thanks
Robert

Should be :

Please Login or Register  to view this content.

Thanks much, Karedog! That code is so slick and amazing.
I tried playing with the previous code and kept getting errors 434 and 13.

I noticed if I took one machine off, the code would distribute to a second Machine 7.
Can you change the code to distribute the jobs evenly where possible to the machines?

Thanks once again.
Robert

karedog thank you its work by setting to break on Unhadled Errors