If you mean a Dynamic Range Name....

That refers to a Named Range that automatically resizes to reflect
changes in the number of items in the range. A common use of a Dynamic
Range Name (DNR) is to use one as the basis for Data Validation. When
items are added/removed from the list, the DNR grows/shrinks to reflect
the changes so the validation list always shows the complete list and
won't show extra blank rows.

For instructions on how to create a DRN, see Debral Dalgleish's
website:
http://www.contextures.com/xlNames01.html#Dynamic

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=547813