I am attempting to populate a drop down list in excel using data validation and data contained in two discontinuous ranges. I have used the Union command in vba to create a named list which seems to correctly concatenate the two data ranges but when I validate the cell which is to contain the drop down list it generates an error which indicates that my data range must be continuous. Is there any way around this? I woudl prefer to keep this solution entire in Excel alone, but I suspect that is not possible.
February 27, 2009 3:43 PM
February 27, 2009 4:21 PM