![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjljWZ06N12wjxyBpCxdpJuLkJvXtWRlK0urd0RZOoQzFBsAJngvNOhMn-46oFNJxUAXOFvK4_jYW3hC7jcZPa4DAj-Bi7PbZbVX5vZ6UbjeOc9Xmstulmyb9QY0jnD6mz7qnSj2p5DM8Ya/s200/visual-basic-906838_960_720.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9hEczPGSVZAfXJl6whIL_TVEB_CDprpdh6rOxL8yiZj_nTlAdZ5WDIjzCn0rIerKPWPQ98ftciYhMzhqexsk7GbPJ_5tNFvHtQjCROM-HvD8rDYEv7ClNM7Eg0x8PmQJHVlPsslm4A2AN/s200/2000px-Microsoft_Excel_2013_logo.svg.png)
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