Thanks again Tom,
I got it working and combined with some other code for this project i
seems to be working well. I'll attach it in case you would like to se
it run. Could not have done it without you!

Still not finished but getting closer each day.

Go to the Task Allocation tab and press the "Closest Yet" button

and Thanks again
Ji

Attachment filename: copy of hotherps7.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=56421
--
Message posted from http://www.ExcelForum.com