in reply to Re^5: Reading Variables in Excel Spreadsheetin thread Reading Variables in Excel Spreadsheet
In depends on the Scope of the named range, either Workbook or Worksheet. If they are all Workbook scope and therefore unique the name is sufficient. If Worksheet specific then add the sheetname ie Sheet1!name
In Excel use Formulas->NameManager to see the details