An easy way, but not the best..
After copying the formula down, hightlight the row, hit ctrl f, find
"B9" and replace with "B10".


--
eklarsen
------------------------------------------------------------------------
eklarsen's Profile: http://www.excelforum.com/member.php...fo&userid=9001
View this thread: http://www.excelforum.com/showthread...hreadid=319649