Delimited List

  • Thread starter Thread starter doss04
  • Start date Start date
D

doss04

I'm creating a document that has several drop down boxes. all are going good
but one. After i validate and good to check the list. A box pops up and says.
"The list source must be a delimited list, or reference to single row or
column". The list i have is on another worksheet in the same workbook. The
list is named ADDRESSES. Can anyone help?
 
I just tried it and the same thing popped up. ?????
The named range ADDRESSES cannot be a multi-col range
Must be either a single col range or a single row range.
Check / amend the named range via: Insert>Name>Define
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:61
xdemechanik
---
 
Thanks Max. I just figured it out. The addresses were in merged cells instead
of one cell. once i deleted the additional merged cells and just left the
cell they were written in it allowed me to validate. A Lot of trial and
error. Lol
 
The addresses were in merged cells instead
of one cell. once i deleted the additional merged cells
and just left the cell they were written in it allowed me to validate.
Click to expand...

The ground refrain is to avoid using merged cells. It can cause a lot of
pain/downstream issues, an example of which you mention above. And the 1st
thing I'd usually do when I work on files sent to me is to check for &
remove all merged cells
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000, Files:362, Subscribers:61
xdemechanik
---
 
Thanks for your Help.

Max said:
The ground refrain is to avoid using merged cells. It can cause a lot of
pain/downstream issues, an example of which you mention above. And the 1st
thing I'd usually do when I work on files sent to me is to check for &
remove all merged cells
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000, Files:362, Subscribers:61
xdemechanik
Click to expand...
 
Back
Top