I'd like to select some cells, and hit a button, and have it automatically name the range using the value in the cell just above the top-most cell selected. If the named range already exists, that's okay, I'd like it overwritten.

So, if I select G18:G28 and hit the button, I want it to use the value in G17 for the name of the range. It will never have spaces in it, if that matters.



This would make a GREAT KB entry, too!