How to Select a Named Range on Another Worksheet in the Same Workbook

To select the named range "Records" on another worksheet (Sheet2) in the same workbook, you can use the following example:

Application.Goto Sheets("Sheet2").Range("Records")

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

Sheets("Sheet2").Activate
Range("Records").Select