Now start the macro in the way you're used to.
Note that Excel doesn't allow breakpoints on comment-only or 'dim' lines.į9 will place a break point on the line, which makes execution stop there as the macro is running. on a line of interest, or on a line slightly before it.
Look up the macro in any 'Modules' (you might need to open a panel in the View menu to see them), there may also be 'Modules' in several places - one being a 'standard' location, and at least one in each open sheet in addition to that.Īs you have the macro code visible Click to place the cursor e.g. Already the most basic level of debugging a macro is useful: This is how to get started Īrrange the prerequisites for running the macro, then press ALT+ F11
0 kommentar(er)
