|To answer your specific question:|
"My source for the drop-down box says this: "=names!A1:A28". Is this what the previous answer suggests by "naming the range"? "
What they mean by "naming the range" is to select the range (names!A1:A28) and then click in the name box above Column A. Enter a name for the range, such as MyRng and press Enter. Make sure you press Enter to set the Name. Don't just click out of the name box because the Name won't stick.
Now, instead of using =names!A1:A28 as your source in Data Validation, you would use =MyRng
Anytime you refer to MyRng in a formula within that workbook, you will actually be referring to names!A1:A28.
Do some Google searches on Named Ranges for more info on the feature.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03