Validation List with Variable Lengths & Invisible Empty Cells

[RobPendulum]

HELP!! Excel is driving me nuts. Is there any way to do the following:
I've got a drop-down Validation cell, which calls upon a List of
selectable resources (40 rows). I currently only have 20 resources in
the List, but I know that I'll be changing and adding resources (40
will be the max) .
The problem is that the drop-down list lists my 20 resources & the 20
empty cells. I've tried some crazy elaborate macros to have Excel
recognize only the listed resources and change the Validation
parameters... but with no luck.

I found the following tip/blurb here called: "Validation list without
empty cells using VBA in Microsoft Excel", but I'm not familiar with
VBA. Is this my solution? How do I implement this? I don't understand
what the author means by:
"Insert the following code in This Workbook module."

Any help is greatly appreciated!!

-Rob Taylor
CEo, Pendulum

 

[Debra Dalgleish]

As answered in .excel.misc:

You can use a dynamic named range as the source for the data validation
list. There are instructions here:

http://www.contextures.com/xlDataVal01.html

In step 2, follow the link to the instructions to create a dynamic range.

http://www.contextures.com/xlNames01.html#Dynamic

 

[Felix]

Now this is a cool idea, that's going to solve some problems I had recently.
Thanks for posting this,
Felix

 

[Debra Dalgleish]

You're welcome. I'm glad it helped you.

Now this is a cool idea, that's going to solve some problems I had recently.
Thanks for posting this,
Felix