Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell validation list reference to a different worksheet
i have a validation list created thru the ususal XL/data/validation...
it refences data in a different worksheet using a named range (created thru XL/insert/name/define...) the named range is defined by this formula: =OFFSET('\\Server\Files\@ Timesheets\[Job Nos for Timesheets.xls]Project List'!$F$3,0,0,COUNTA ('\\Server\Files\@ Timesheets\[Job Nos for Timesheets.xls]Project List'!$F$2:$F$506),1) as the worksheet evolves, it would make sence for the list to vary... so, i tried redefining it thru VB, its result in an error... actually, if i do nothing but create a named reference to a list in a different workbook ex: '='[Job Nos for Timesheets.xls]Project List'!$F2:$F500" --- i get an error: "cannot reference a different workbook for validation... or something like that... or must be a delimited list..." UGH! yet i had been previously ??? as always, thanks in advance, mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet reference in validation | Excel Discussion (Misc queries) | |||
validation list on different worksheet | New Users to Excel | |||
drop-down list validation won't allow a different worksheet | Excel Worksheet Functions | |||
Data validation list from another worksheet? | Excel Discussion (Misc queries) | |||
Validation - List - Separate Worksheet | Excel Worksheet Functions |