Thank you both very much!!!!

This is going to make a lot of our manager's lives a lot easier. Scheduling
has always been a very time consuming process, but with the great help you
both provided me, scheduling time has probably been cut in half. And, as an
added bonus, I've learned a lot more about some of Excel's functions.

Paul

"pinmaster" wrote:


Hi Paul,

I don't know why I didn't think about this last night but you have to
make the range reference absolute.

=$B$42:$B$60

Regards
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=499123