![](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 range E5:J10 on a worksheet (Sheet5) in a different workbook (Book5.xlsx), you can use either of the following examples:
Application.Goto Workbooks("BOOK5.xlsx").Sheets("Sheet5").Range("E5:J10")
Application.Goto Workbooks("BOOK5.xlsx").Sheets("Sheet5").Range("E5", "J10")
Or, you can activate the worksheet, and then use method 4 above to select the range:
Workbooks("BOOK5.xlsx").Sheets("Sheet5").Activate
ActiveSheet.Range(Cells(5, 5), Cells(10, 10)).Select