Joe

Debra Dalgleish has instructions for this at.........

http://www.contextures.on.ca/xlNames01.html#Dynamic

Also check out her info on Data Validation lists.

http://www.contextures.on.ca/xlDataVal01.html

Gord Dibben Excel MVP

On Tue, 17 Aug 2004 10:03:01 -0700, Joe wrote:

I am using XL 2002. In my workbook I have a sheet that stores the values
used for validation lists. One such list is SalesReps. This is a dynamic
list. If I use a named range for the values in the list, and the list either
grows or shrinks, I will need to use a formula for the RefersTo property so
that when this list is referred to in data validation it will be accurate.

Does anyone know how to code this or what formula I could use to make the
RefersTo dynamic?

TIA,