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