Cool, that worked exactly how I wanted it (Ill have to look into that
INDIRECT function). The only problem that I have now is if I have two
blank cells together in column D (like a row 9 with nothing in it) then
I get a circular reference error.

Thanks for your help!


--
c_schear
------------------------------------------------------------------------
c_schear's Profile: http://www.excelforum.com/member.php...o&userid=16494
View this thread: http://www.excelforum.com/showthread...hreadid=278720