Hi,
I have several cells with data validation's drop Box. Every data validation uses a range name as source (myColorList).
Here goes the hard part:
I need a new value inside the dropBox list, but The problem is that I can NOT modify the "myColorList" range.
-- Is there any way to build up the dropbox source using the range name and the new value? Something like(which I already tried with no success)Please Login or Register to view this content.
Bookmarks