Even better use a named range | Message 14 of 43 | TechRepublic

Discussion on:

How to add a dropdown list to an Excel cell

View entire thread

Message 14 of 43

Next » « Prev

0 Votes

+ -

Even better use a named range

Instead of hard coding the range of cells for the list, if you use a named range then you can increase the length of the range without having to change your validation settings.

Posted by Solarfish

13th Jun 2008