Ok Frank, thanks for your response. One more question what if th
variables for my formula change as the code loops through the range
Let me be more specific.

I'm trying to assign tasks to people that are working on a shift. Th
need for tasks is calculated in hours. So I want to be able to assig
someone to a task by adding a short text value to a cell in thei
shift, so they can see what task they are assigned to for tha
interval, usually in groups of 4 cells at a time.

So the task must have a value greater than 0, the need must be withi
the employee's shift, and the employee must be trained in the task.

So for each cell in the loop range these 3 three conditions have to b
checked for. If any one of the three can not be met, the code shoul
check for the next task, and so on.

I'm not sure how I would have the formula change to check for th
other tasks as they are needed.

Does that make sense? Is there a way to have the code check all thre
parameters before populating the cell?

Thanks again for your repl

--
Message posted from http://www.ExcelForum.com