

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
No comments:
Post a Comment