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