in reply to Re^5: Reading Variables in Excel Spreadsheet
in thread Reading Variables in Excel Spreadsheet

In this test case no. However, in 'production' yes.
  • Comment on Re^6: Reading Variables in Excel Spreadsheet

Replies are listed 'Best First'.
Re^7: Reading Variables in Excel Spreadsheet
by poj (Abbot) on Jan 15, 2018 at 18:01 UTC

    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

    poj