Discussion on:

Message 1 of 3
0 Votes
+ -
Tip for Method 2
Nice article. Here is something I do:

At the bottom of the validation list , in the cell after the range ends, I key in something like "--End of List ---" to remind me that when I fill the empty slots and need more I need to also expand the named range.
Posted by mhatherly@...
23rd Feb 2012