check out this site to learn dynamic ranges, as the list increases s
does the range

http://contextures.com/xlNames01.html#Dynami

--
davesexce

-----------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...fo&userid=3170
View this thread: http://www.excelforum.com/showthread.php?threadid=54153