crashes

Hello, I am very confused. My macro was working perfectly opening files and consolidating and now it crashes every time I try to run it on the first line of code. Sub PerformAll() Dim wbSource As Workbook Dim wbDestination As Workbook Dim wbSource2 As Workbook Dim wbDestination2 As Workbook...

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

Hi there, I am new to VBA and just used YouTube to create a calculator for work. My colleagues and seniors (who have seen it) love what Excel can do as it will save so much time. In order for the company to want to proceed it requires testing, however I cannot do this due to the following...

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

Hi, I made an Excel file with activex drop down & Text boxes. Some of them are hidden and appear only when other comboboxes have certain values. This all works fine. Except when I try to save my file. It saves as a .xlm file. If I save it without any hidden comboboxes/textboxes/rows; it...

Hi everyone, I have been experiencing random Excel crashes when I use the function "ComboBox.AddItem ArrayDirector(i, 1)". The code works perfectly 8 out of 10 times, but every once in a while Excel crashes at the same .AddItem function. This problem only happens when I start my...

I've dug and dug and dug online to try and solve this before coming here, so I hope someone can help me. I have really simple vba in this report to auto apply a couple of filters to the data by clicking a button. At some point, something happened that made it so when I opened the file, I could...

Recently installed Office 2016 in Windows 8.1. With multiple XL files open, when closing a single file without saving, the program crashes without exception. I have the following add-ons active: - securisync office plugin . send to bluetooth Looking forward to any suggestions. Drives me crazy...

Hi I have a small .XLSM file which crashes every time I try to open it with the message: "Cannot complete operation; a table cannot overlap ... Excel then goes away for a while & then stops working. This applies to all copies The file has 4 queries from MSQuery all located adjacent on the same...

I have a macro that takes different ranges, performs calculations with values in them, and then copies the value to a cell to be available for use to formulas in the worksheet. I want this macro to run when values in certain ranges are modified. I use this same code in different worksheets...

I am using Excel 2013, and have setup multiple userforms that work fine, until I add a ListBox. I am familiar with userforms and have setup 100's in 2003-2007 with no problems that include listboxes that refresh after data is added. Using 2013, if I use the same method and code, it crashes and...

I've been working on an excel planning tool for the past few months, it contains 6 sheets, some user forms, some modules, and loads of vba code. some times during this months excel has crashed on me due to infinite loops and computer crashes. after some crashes excel needs to repair the program...

Hi, I am new to the forum and also to creating macros in excel with vba. I have a similar problem to many people around this forum, but the answers i read didn't seem to help my case. The thing is that i have two sheets which have tens of thousand lines each. In one of them I have the...

Hello all, I use Excel for Mac 2011 on a 3 year old MacBook Pro 17". A few months ago, I had open two Excel worksheets that were a tab-delimited text (.txt) file and a regular file (.xlsx) (a Word document file [.docx] was open in the background). I copied around 850 cells from the .xlsx...

Hello all, I have a MacBook Pro that is 3 years old that has undergone some physical damage (a few drops). A few months ago, I was working on two Excel worksheets (one had >850 rows and 3 columns and one had >12000 rows and 24 columns) and a Word document (around 60 pages long)...

I am including the code below: The code should delete a sheet and then remove the index entry from the Main Page called "Working Lead" When ever I delete a sheet Excel shuts down with an Unexpected error. Excel 2010 & Win7. Look For The Green Comment Line below - This is where the crash happens...

Hi, My company has a database created on Access 2007 that is linked to our company's Sharepoint. Authorized users can go onto this access file and make edits that are automatically shared to the site. This works fine on Access 2007. However, the company is upgrading to Office 2010, and...

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

I have 2 columns of data (x's and y's) which I want to integrate to find the area under the curve. This part is ok when I use all the data. I use the OFFSET function in named range to create a dynamic named range. I want to go further with this though however as the data is really a mixture...

This is an age old question that people everywhere have tried to solve. I didn't notice it in this forum though. How do you prevent excel from crashing when you rename a worksheet if you have udfs. You'd figure by 2010 this would be solved, but it isn't.