crash

(COUNTIF($A$2:$A2,$A2)=1)+0 So running this formula to de-dup 200K lines of data causes excel to crash (90% of the time). Any suggestions to optimize it are welcome.

Excel crashes (no response) when a value used in VBA is selected from a ComboBox. It does NOT crash when the value is entered into the ComboBox (rather than selected). My previous thread gets into all the attempted fixes that proved more of a distraction than anything. The Workbook has been...

I have an Excel 2007 macro that is really quite simple (but large) that looks through 14 open workbooks, takes some basic data from each and transfer the results to another workbook. It has been working fine until last Monday. Now, if I make any changes to the macro, even just adding a comment...

Sub CopyInsertRow() On Error Resume Next Selection.EntireRow.Copy Selection.EntireRow.Insert End Sub I've run the above script a ton. I've got it shortcut key'd. Sometimes I run it 5 or 6 in a row. Almost daily, directly after running it, Excel will crash and I'll get that "Excel...

I have a new PC (Windows 10 Pro 64 bit) with a fresh install of Office 2016 32 bit. In VBA editor, clicking (left or right) on ThisWorkbook causes Excel to crash and either close or restart (different behavior at different times). This occurs in a new, blank Excel file and in files with...

Afternoon all, I have several files that open perfectly on my machine but when a few others open, it causes theirs to crash. The file is set up in office 2016 and the person who is having the problem is using Office 2015. I notice in my project library that I have Microsoft Office 16.0...

Hello all, I have managed to break an excel reporting workbook I was working on and I would greatly appreciate any help you could provide with this issue. The problem is with running a macro in the Excel workbook. The userform opens fine so I can enter data, but clicking the macro button on...

Hi My VB Errors out here *Compile error Variable not defined* Private Sub cmdNew_Click() Dim answer As Variant blnNew = True :crash: txtContactPerson.Text = "":crash: txtCustomerNumber.Text = "" txtCustomerPhone.Text = "" txtCustomerLandline.Text = ""...

Recently, an .xlsm workbook of modest size caused Excel to crash upon saving, for both 2013 and 2016 versions. Additionally, Excel would crash with the workbook open while it was just sitting there inactive. Removing conditional formatting from the workbook cured the crash upon save. The...

I created a very basic invoice system for a friend in Excel/VBA. The system works fine for me on my PC and my laptop but when I took it to his house it keeps crashing on his PC (not responding errror), he can add the invoice fine but when he then click a button which sends him back to the home...

i am new in excel VBA, and after finishing below code, the function of the code is running very well and i can save it but when i try to close it i have not responding error and it crash all excel and restart it, the code has been used is : Code in workbook : Private Sub Workbook_Open()...

I have created a basic invoice system for a family member - it uses a few macros and a bit of VBA code. All it does it once he has filled out the invoice it copies a few of the details onto a invoice list sheet for the accountant and his records. However it keeps crashing on his computer and...

Hello, I recently wrote a simple Macro to calculate something using a for-loop. The Macro works fine, except that Excel crashes every time at the end. After some researching I found that the probem lies with re-activating the Automatic Calculation (which I set on 'manual' at the beginning of...

Hi guys, I have this macro which checks against the date and name of today's data in yesterday's data, and then copies over all the rows that have match the criteria. Problem is that there are about 67000+ lines, and Its been running format least 2 hours right now. Is there a way for it to be...

Hi, Can anybody tell me why this code is crashing and also suggest a more efficient code maybe? <code> Function Factors(x As Double) As String Application.Volatile Dim i As Double Factors = x For i = x - 1 To 1 Step -1 If x - (Int(x / i) * i) = 0 Then Factors...

Hi All, I have what I believe to be a basic marco which usually runs fine but at times the code seems to get stuck in a loop and I have to force excel to close. Is the code in a bad format? How can I fix this issue? I believe it might have something to do with the loop or "On Error Resume...

I have been trying to copy comments over using VBA and every time I do it will work until I open the excel file again and then it crashes. I don't know that it is a problem with the code but perhaps how the pictures are viewed. I have them as comments with the background being pictures...

Hello, I'm hoping to get help with the following challenge (man - I appreciate this forum!) I will provide the user's sequential steps, problem statement, hypothesis, and then the code. Usability Steps: 1. User opens .xlsm file (there are about 15 users in which each has their own unique...

When I run this code, Excel will crash when it reaches the last line, i.e where I close "document2". Any thoughts? I've used similar code before and it has always worked. Option Explicit Sub DAILYSALES_END() Dim rownum As Double 'save document1 at temporary location...

Hello, about 50% of the time when I close Excel, and VBA password box appears asking for a password (duh). I am having a hard time identifying what is causing it to appear, and when I try to cancel the box it causes Excel to crash and restart. I do have before close code, however I have ruled...