Excel 2003 VBA drop down list and discontinuous ranges

10 pts.
Tags:
Excel 2007
Microsoft Excel
Microsoft Excel 2003
VBA
VBA EXCEL 2003
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: