Download the file he
http://download.microsoft.com/downlo...s/solverex.exe
Use the macro New_Employee_Schedule() as a guide. It has constraints.
Yes, you can use a range-name in lieu of cell addresses.
Don't forget to set a reference. See http://support.microsoft.com/kb/843304
for more info.

Hth,
Merjet