debug mode

  1. X

    Macro runs in debug mode perfectly fine, but when i try to run it normally it errors out

    Hello all. The title basicly says it all. I have a macro which just adds sheets with a desired name. When i wrote the code i looked if it works as intended in debug mode. But as soon as i wanted to run the macro normally it errors out. the code that i run is as follows: Sub killast() With...
  2. H

    2 files 2 macros nothing but debug mode.

    Hello, I hope this is straightforward enough. I have 2 spreadsheets (files) that have nothing to do with each other. Both have macros running. However the macros keep bumping in to each other and go in to debug mode. If I only have one of the spreadsheets open everything runs fine, as soon as...
  3. J

    Code works in Debug mode but will not run through when played

    I put together about 10 separate macros that will log you into a site using the values in a given cell. I was having trouble with the last one because of AutoComplete remembering the username. So I put in an IF statement, and when I used F8 to go line for line, it works perfectly. However, when...
  4. E

    VBA loses debug mode after file operation (Win7)

    Since being updated to Windows 7 on my laptop, I have been having problems when running a VBA macro in Excel 2003 in debug. Pressing F8 to step forward works ok until I reach any file related operation (e.g. Workbooks.open), after which debug mode is forgotten and the macro continues to end (or...
  5. E

    Delete OLEObjects in Break Mode

    Hi, I am writing some code that will create random data which will be used in a specific sheet to calculate certain values using the cell formulas. This sheet will be copied as many times as necessary to input the numbers generated (The code will generate a different set of numbers for a...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top