opktr.blogg.se - Debug excel file

There are 3 sheets, named "Intro", "Sheet2"Īnd "Sheet3" - there isn't a sheet named "Main".

Look in the Project Explorer window, and check the list of sheets.

Excel showed the error message, because it can't complete the.

The VBE opens, showing the GoToMain Sheet macro, and a line ofĬode is highlighted in yellow, with a yellow arrow n the margin.

In the error message, click the Debug button.

We'll use the Debug button, to troubleshoot the problem:

Here is the VBA code, for the GoToMainSheet macro: Sub GoToMainSheet() In this example, a macro was recorded, to go to a sheet named "Main",

To go to the VBE and try to solve the problem, click the Debug.Possible causes and solutions for the Subscript You would end up on page on the Microsoft website, with a list of To get information about the error, click Help.To stop the macro, click the End button.On this error message, there are 3 buttons available - End, Debug Occasionally, when you try to run a macro, an error message willĪppear, such as the "Run-Time Error '9': Subscript Out of More Tutorials Error Message Debug Button