Excel 2003 VBA drop down list and discontinuous ranges
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.
Software/Hardware used:
Software/Hardware used:
ASKED:
February 27, 2009 3:43 PM
UPDATED:
February 27, 2009 4:21 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
