Ive been playing around the list command in validation and I was wondering if
there was a way to use ranges from 2 different worksheets to be the source to
select from. I've tried using the name box command to name the cells and
create a union, and that wont work, and something like the 3-D command wont
work because I've already programmed a few macro's that are referencing those
cells.