PDA

View Full Version : Application.Goto not working in immediate window



fb7894
03-09-2018, 06:13 AM
I just upgraded to Excel 2016. I always use the Application.Goto command in the immediate window when debugging.

It is not working like it did in Excel 2010. It does not give an error. But it does not go to the range. Any advice on this?

Paul_Hossler
03-09-2018, 07:03 AM
I have 365 and this works from the Immediate Window



application.Goto range("Z2")

fb7894
03-09-2018, 08:53 AM
Does it work properly if you have another workbook active?

Example WB1.Worksheets(1) is active

Application.Goto WB2.Worksheets(1).range("A1")