='[Mybooks.xls]Sheet1'!$A$1:$A$20

Data validation won't work with a closed workbook anyway.

--
Regards,
Tom Ogilvy


"Mark J Kubicki" wrote in message
...
trying to create a named range for use as validation list in a cell drop
down
the range is in a different workbook

...can't even get the basics right -UGH!


Private Sub Workbook_Open()
Const ProjectDataFile = "Job Nos for Timesheets.xls"
Const ProjectDataFilePath = "E:\"

ActiveWorkbook.Names.Add Name:="ProjectNames", _
RefersToR1C1:="=workbooks(ProjectDataFilePath &
ProjectDataFile).worksheets(Project List).range($F$2:$F500)"


thanks in advance, mark