crashing

I have a laptop with Excel 2016 (365) installed which started playing up this morning. When ever i try to open a Macro enabled templates, excel crashes. There is defiantly nothing wrong with the code as the template is used on 30 other laptops and has been used for several years. Macros are...

So I have a macro to add a line to a database I've created by copying an existing line and inserting above then clearing the data. Mostly it works fine, but every once in a while for no reason that I can tell, it will suddenly give me an error. Usually happens when I am running the macro a few...

It saves just fine, but then crashes. Details: Multi tab (approx 35) tab workbook (workbook size 3700kb) with some fairly basic macros (none of which trigger at close or seem to cause any other problems) It doesn't matter whether I hit save separately and then close, or if I hit close, say...

Programing a procedure which opens a .ppt template and copies in charts and tables from Excel for multiple generation of presentations (a Do Loop) for a new .ppt per record on a specific worksheet. What appears to be an every-other-time/record event, the pasting of an Excel chart is interrupted...

I can't apply a simple VLOOKUP across the data set I'm working with because it's so large (700K rows). I'm working out of a 32-bit excel and it's the only version I have access to. I've saved the file as an .xlsb to try to save space, but that didn't help much. I have to apply the formula to a...

A large (100+ files) xlsm of mine started to hang intermittently several weeks ago. Sometimes it will happen on a compile, more often it will be on save. The environment is Win 10 pro and Excel 2013. When it crashes on a save it often leaves a temp file (ie, "FF4DE000") in the workbook...

I am new to macros and recently upgraded from 2013 32 bit to 2013 64 bit. Under 32 bit, my team and I were successfully using a macro that automatically opened password protected files on our network shared drive. However, now that we've switched to 64 bit, the file crashes almost every instance...

Hello, I am trying to run a macro update on a file with a lot of excel formulas that cause the file to act very slowly when set to Automatic update. The macro involves pasting various data sets from other files into the current file, applying various formulas to all rows in those datasets, which...

Hello, I have a very large excel file with around 30 million cells, with approximately 2 - 3 million of those cells being formulas. The file is about 250mb. When doing a sort, adding or deleting columns, or pasting formulas, Excel either can take around 5 - 10 minutes to complete the task, or...

Hi, I am working a lot on Excel and in the past 2 months (maybe since I updated to windows 8.1), Excel keeps on crashing on regular basis and I have the following message: " Microsoft has stopped working A problem caused the program to stop working correctly Windows will close the program and...

Hi, I hired a programmer to have a desktop application to extract data from a website containing 160.000 rows and 20 columns. The programmer can download the entire 160.000 items in one single file. I can't manage to do it and it crashes at the end of the data extraction when it is time to save...

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...

Hello there, I am facing problem with excel crashing when I delete two sheets using macro as follows : All I want to do is to delete two sheets named KrSh_H and UvArg_H and make fresh copies of two other sheets and name them same as deleted sheets. I start with a sheet called "1Rx1" and refer...

Ok. I am new to this board but have been playing with VBA for a couple of years. A workbook I have developed over a year now randomly decides to crash. Sometimes it fails to find an object, like a userform, that absolutely exists! On restart excel usually finds unreadable data in the xlsb file...

When I run the following userform code, it will run once. After that I receive a Run-Time error '-2147417848 (80010108)': Method 'Value' of object 'Range' failed. After clicking end on the prompt, Excel locks up and I have to end the process. Upon opening the document, the data for the second...

This was offered as a solution to another's post... http://www.mrexcel.com/forum/showthread.php?t=465898 but I got a bug in it. I've got the following code to save a copy of the current file to another location... (To test this out, I used my Desktop[shared] and My Documents[master] as the two...

I'm building a small interface and I need the user to input a value (from 1 to 50) in one cell, and for the spreadsheet to dynamically create a little table with the number of columns they enter. Here's the code I'm using -- its crashing my Excel 2007. Just an FYI, its running in compatability...