Use =AJ32:AJ40


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Bob Newman" wrote in message
news:gWXOg.45523$ok5.3345@dukeread01...
Excel 2003

DATA/VALIDATION
Allow:List
Source:AJ32:AJ40

When I click on a cell with this validation setting and pull down the
dropdown arrow "AJ32:AJ40" appears as the only choice in the list rather
than the text in that range. What am I doing wrong?

Thanks in advance... Bob