ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Application.goto Workbook? (https://www.excelbanter.com/excel-programming/351644-application-goto-workbook.html)

DJB[_12_]

Application.goto Workbook?
 
Can you use Application.goto and goto a Workbook or a worksheet?

I get an error object required?

Thanks



Norman Jones

Application.goto Workbook?
 
Hi DJB,

Application.Goto Workbooks("Book1.xls").Sheets(1).Range("A1")

worked for me.


---
Regards,
Norman



"DJB" wrote in message
...
Can you use Application.goto and goto a Workbook or a worksheet?

I get an error object required?

Thanks






All times are GMT +1. The time now is 10:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com