Name a dynamic range

[2funny4words]

I have named dynamic ranges before but it has been a year or so since I have done it and I can not remember where to go to do it. The range is for a data validation drop down list that may grow. The formula that I think I should use is

Please Login or Register  to view this content.

The range the I need to name is in the worksheet Lists and the range should be d2:d100 did I make the formula right?

Thanks in advance.

[NBVC]

In XL2003, go to Insert|Name|Define

In XL2007, go to Formulas|Define Name

Formula should be:

=Lists!$D$2:INDEX(Lists!$D2:$D$100,COUNTA(Lists!$D2:$D$100),1)

or if you don't want to limit to D100

then:

=Lists!$D$2:INDEX(Lists!$D:$D,COUNTA(Lists!$D:$D)+1,1)

[2funny4words]

That is what I needed,


Thanks