-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
break mode
-
J
Run-Time Error 1004 when Stopping Application.OnTime Procedure
I wrote a macro that allows a user to time the duration of their call through a UserForm, while they continue to enter data about their call on an excel sheet. Most of the time the macro works perfectly but occasionally (randomly it seems) I get an error when attempting to pause/stop the OnTime...- JGBlue
- Thread
- Replies: 2
- Forum: Excel Questions
-
E
Code runs in break mode, but not otherwise!
Hi all, I have a code that is replacing hyperlinks to open word documents on a networked document as everyone has a unique identifier for the initial drive on the network. For example, I am on the H drive, but the same document for a colleague is on the N drive. I've created a range in excel...- ExTeacher
- Thread
- Replies: 8
- Forum: Excel Questions
-
O
Get to know if in Break-Mode and/or on what line?
Is there a way to know programmatically that we are in BreakMode and maybe even know on what line? I found out that using apostrophes one can start OnTime with parameters and not having the error "Can't execute code in break mode". Application.OnTime now, "'MySub " & now & "'" This will...- onidarbe
- Thread
- Replies: 1
- Forum: Excel Questions
-
H
Pivot Table refresh only works in debug mode..!?
Hi all, I have a workbook which contains a link to an external SQL procedure to bring in data. The user will select parameters in the spreadsheet and run the macro to retrieve the data and then will be shown a pivot table of the results. The data actually goes initially into a normal table...- High Plains Grifter
- Thread
- Replies: 13
- Forum: Excel Questions
-
P
Break Mode message
I'm currently working on some VBA code and I'm getting a strange "can't execute code in break mode" error. The macro runs fine in excel, but the problem arises when I try debugging it with VBA. Any time I step past a line selecting a different sheet or adding a new one this message box appears...- Plowman
- Thread
- Replies: 0
- Forum: Excel Questions
-
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...- er300905
- Thread
- Replies: 0
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Help with summation of different rows in 1 column
- Started by bassemjohn1
- Replies: 30
[B]Hello guys, [/B] I am new here and am in need of your help,I have a report that is really taking a huge time and all I need is a [B]way to sum... -
Excel VBA Code to Compare Rows in Two Different Sheets and Highlight Only the Cells that are different/unique
- Started by Walkerwood9
- Replies: 25
I have a workbook that has two sheets in it and I want to compare these sheets (Test1 and Test 2) and highlight only the individual cells that are... -
COUNTIFS function help please
- Started by andrewmurray86
- Replies: 25
Hi all, This is my first post here: I'm attempting to identify the smallest number within a column. I have a series of sheets with a column... -
Move row automatically to the bottom of the sheet when cell changes
- Started by CindyLou
- Replies: 23
I have a column of "Open" and "Closed" items. When the cell is changed to "Closed," I'm trying to get the whole row to go to the bottom of the... -
Change date format on import
- Started by namloop
- Replies: 37
Good morning I am importing some data and I am having two different issues in col. B. In rows 3 this data says Nov-9 (the 9th of November) when I... -
Problem with macro
- Started by Jeeremy7
- Replies: 20
Hello, I have a macro running but i think some informations are in double so the macro doesn't work.. If somoene could help it would be really...