How to Select a Named Range on a Worksheet in a Different Workbook

To select the named range "Records" on a worksheet (Sheet 5) in a different workbook (NewBook.xlsx), you can use the following example:

Application.Goto Workbooks("NewBook.xlsx").Sheets("Sheet5").Range("Records")

Or, you can activate the worksheet, and then use method 7 above to select the named range:

Workbooks("NewBook.xlsx").Sheets("Sheet5").Activate
Range("Records").Select