crash

I'm having an issue with this piece of code causing Excel to crash every time it is run. When I remove the bold section, it runs just fine. Any thoughts on how I can get this to work? Is Excel being overloaded? (I'm not great with VBA, but what i'm trying to do is select the pivot table in the...

Hi All, I have a form thats coded so that users on the network can submit entries on to a master workbook. The code checks if the master workbook is opened, if it is, a message will pop up asking them to try again. If not then it opens the workbook and theres a few simple copy and pastes...

I'm having a very weird error occur with a userform causing excel to crash. A little background, I'm working on a large project that has multiple goals with varying data entry points. I have a macro command button on the first worksheet which opens the intro user form. This intro userform lays...

I am using excel and VBA to download a number of web pages and parse data from those webpages. I have my code set up but on occasion (every several hundred pages) the application crashes because it can't get a response from the internet. My question is can I add code that essentially instructs...

Dear community, I am using Excel 2007 (32Bit) on a Windows 7 64Bit machine. I have a large Workbook with 12 sheets and 18 VBA modules. All of my subroutines run flawlessly but one is causing the following issue: The macro itself runs from start to finish successfully just as specified. After...

Hi folks, I'm new to this forum and an intermediate level user of Excel and VBA. I have made a rather simple code in my Excel 2010 workbook/VBA project to print one sheet and at the moment I continuingly run into this nasty problem: Excel occasionally gives me (only sometimes!) the error...

Hi all, I have the below code, it opens several different spreadsheets, applies some formula and filters out duplicates and copies all that data to a new workbook. Every time it goes to filter out the duplicates on the larger sheets, it crashes. Can anyone help? Sub HighlightDupes()' Dim...

Has anyone ever run into this problem before? I have an extensive .xlsm which uses the simple command line : ThisWorkbook.worksheets(1).listobjects(1).listrows.add And 2 out of 3 times, it will cause a run-time error which will then crash Excel and restart it. The full piece of code is as...

Hello All, I started my first VBA project for work and am now at my wits end with this (hopefully) last problem. My macro runs absolutely fine, but after it is done running when I try to save/save-as the file containing the macro it crashes all of Excel. I am given the below error details...

Just like the title says, I have a fairly large amount of data reporting into a pivot table. I made this on windows and it works perfectly fine. I sent it over to someone with a Mac (their excel is fully updated), and after they modify the source data and try to refresh the pivot table, Excel...

I have a spreadsheet with drop down criteria that queries a database. A 'command button' prompts the user to 'refresh' the data. The macro is very simple. ' ActiveWorkbook.RefreshAll ' When 'clicked' on a 64 bit pc - Excel crashes. The only way out is to 'End Process' via Task Manager. If I...

I had run the following simple code in excel 2003 well, but when I open the file in excel2013, excel may crash. please give me ideas Private Sub WorkSheet_BeforeDoubleClick(ByVal target As Range, CANCEL As Boolean) ActiveWorkbook.Close End Sub the following rus well both in excel2003 and...

Within the Excel 2007 Visual Basic Editor, when I declare a variable as a Worksheet object and then, within a subroutine, set that variable to point to a worksheet object, if I start typing the code 'ws.', Excel crashes. Normally upon typing the . after ws, I would expect the Visual Basic...

Hi All, I have 16GB of RAM and I'm only using 4.5GB currently and only 10% CPU. Has anyone encountered this error message before? [Not enough resources in Excel to perform task]. Any solutions/settings to pursue? Thanks m

Hi, Using Excel 2007, I have an .xlsm file with a custom ribbon tab containing Button and Separator controls. Quite frequently, when the workbook is closed, Excel crashes. I think there is a problem when the customised part of the ribbon is unloaded. The workbook does not contain...

When I first publish to a web page in Excel it publishes fine, I can add to the web page, and I can update the data and it will republish fine. Then one time after it saves and is about to republish, it will crash. Every time after that first crash it will crash when trying to publish. I can...

I am trying to reorder the sequence/order in which a tab button will take my database users through the fields (nothing to do with tabs on sub-forms). I have been told that this can be achieved by going through the Arrange tab on the menu bar and selecting Tab Order. However, as soon as I...

This happens to me periodically, maybe twice a year: I realize I need my arrays to be bigger and when I alter the Dim statement, Excel crashes. At one point I was able to export the module, remove the module, and then import the module to fix the problem. But now I can't even remove the module...

When I click the Data tab in excel 2007 version excel crashes. I noticed that if I close my addin file it then does not crash. Has anyone had any experience with an addin that causes excel to crash when clicking on the data tab???

Hi. I'm trying to record a relatively simple macro to sort and transpose a set of values (among other things). I've saved the macro in my personal workbook, but it crashes when it hits the sort command every time. Commands prior to the sort all work. I've recorded similar macros in older...