If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Delimited List
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? |
#2
|
|||
|
|||
Delimited List
Recheck your data validation range
In the "Source" box, it should read as: =ADDRESSES Amend as required OK -- Max Singapore http://savefile.com/projects/236895 Downloads:19,000 Files:362 Subscribers:61 xdemechanik --- "doss04" wrote: 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? |
#3
|
|||
|
|||
Delimited List
I just tried it and the same thing popped up. ?????
"Max" wrote: Recheck your data validation range In the "Source" box, it should read as: =ADDRESSES Amend as required OK -- Max Singapore http://savefile.com/projects/236895 Downloads:19,000 Files:362 Subscribers:61 xdemechanik --- "doss04" wrote: 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? |
#4
|
|||
|
|||
Delimited List
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: InsertNameDefine -- Max Singapore http://savefile.com/projects/236895 Downloads:19,000 Files:362 Subscribers:61 xdemechanik --- |
#5
|
|||
|
|||
Delimited List
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 "Max" wrote: 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: InsertNameDefine -- Max Singapore http://savefile.com/projects/236895 Downloads:19,000 Files:362 Subscribers:61 xdemechanik --- |
#6
|
|||
|
|||
Delimited List
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. 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 --- |
#7
|
|||
|
|||
Delimited List
Thanks for your Help.
"Max" wrote: 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. 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 --- |
Thread Tools | |
Display Modes | |
|
|