Dave Peterson wrote...
See Debra Dalgleish's site:
http://contextures.com/xlfaqFun.html#SheetName
....
If OP has Excel 2003 and would never be sharing files with users of
Excel 2000 and prior, there's also XLM.
Define WSN as =GET.WORKBOOK(38).
Warning: copying formulas containing names that call XLM functions in
their definitions and pasting into other worksheets will ALWAYS crash
Excel 2000 and prior with complete data loss.
The advantage of GET.DOCUMENT vs CELL("Filename",...) is that the
former works whether the file has been saved or not.