-
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.
stopped working
-
L
Excel 2013 Query stopped working
For the last several yrs I have queried a URL and downloaded that table to a worksheet then used the data to populate another sheet. The query no longer loads the table data, only general info from the page. here is the URL...- l_eonandr
- Thread
- Replies: 0
- Forum: Excel Questions
-
R
VBasic - command buttons stopped working
I have a Mastermind game sheet that uses many command buttons. After several YEARS(!), it suddenly stopped working. I'm using Excel 2010 at the office but the workbook is saved as Excel 97-2003 for compatibility with my home PC (this has worked fine for years). The buttons are all enabled and...- RogerThePerson
- Thread
- Replies: 16
- Forum: Excel Questions
-
S
excel crashing when 'macro' icon is hit
I have a set of macros I run in the course of preparing a weekly report. The first macro is used to clear out unneeded columns from a database dump (I can't control the outfeed and get more columns than I need). I run the same macro on 4 different sets of data, each output from a separate...- ssquirrel
- Thread
- Replies: 3
- Forum: Excel Questions
-
U
Excel has stopped working.
I have a macro that does not have any issues until it hits the following module that I have used many times before. The program does everything it was intended to do and emails the completed document to the next person. Then it closes the workbook using the following code. Public Function...- USAMax
- Thread
- Replies: 3
- Forum: Excel Questions
-
R
Stopped the flicker then added a protect/unprotect to the macro and flicker started up again??
Hi there, I have the code below that hides rows if the test cell is 0 or blank. The screen on sheet 1, which drives the results for this "Q U O T E" Sheet, was flickering badly when every drop down box or tick box was selected. I Fixed that with "Application.ScreenUpdating = False" However...- RobbieNZ
- Thread
- Replies: 0
- Forum: Excel Questions
-
C
Macro ran yesterday doesn't run today
I have a file, that has some sheets that are protected at times and are open at other times (depends on who needs to use them). In it, there are two macros used to make the reports contained in the file update show current activity. The file is one of thirty that are set up the same way. All...- Chris.DaRockman
- Thread
- Replies: 0
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Finding issue in If elseif else with For each Loop
- Started by Arunachaljois
- Replies: 57
Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please... -
VBA to copy certain columns from multiple workbooks with multiple worksheet based on criteria into master workbook
- Started by nathanmav
- Replies: 52
Hi everyone, I would like to ask for help about the code I found and I tried to modify it but I'm not lucky to make it work. I have a total of... -
Frequent Text - Duplicates
- Started by SaraWitch
- Replies: 30
Hello all, I'm using the Index, Mode and Match array formula to show the most frequently repeated text. However, I wonder if there's a formula... -
Timer in VBA - Stop, Start, Pause and Reset
- Started by Anton1999
- Replies: 28
[CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub... -
how to updates multiple rows in muliselect listbox
- Started by jaym6939
- Replies: 26
Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code... -
Multiple Case statements
- Started by davidausten
- Replies: 26
Im using a combo box to select the option. The thing I am having trouble with is that if you select the second case statement from the list (they...