Hi Liz,
In addition to Dave's suggestions, you can select your ranges in code.
I named two discontinuous ranges, First and Second, and then selected them with
Range("First, Second").Select
I haven't yet solved reading them into an array and selecting the array, but this may suffice. The 30 ranges will make for a long statement, but will enable you to eliminate user error.
Possibly a loop with the Choose function...hmmm...
Bye,
Jay