crash

Hi all, I seek your help again. I have this VBA: Sheets("Data_analysis").Select Set pvFld = ActiveSheet.PivotTables("Data_analysis").PivotFields("Entered on") strFilter = ActiveWorkbook.Sheets("MAIN").Range("C3").Value pvFld.PivotFilters.Add2 xlCaptionEquals, , strFilter It worked...

Hi guys, I need some help. I have a file with a few macros, and it was everything working as expected, but today my excel started crashing and closing when I run one of the macros. I was making changes to the file, and the macro was working, but sudently, It started closing excel. The code is...

Sub Sheet_Select() Dim sht As Worksheet 'select Macro Controls Sheet Set sht = Sheet1 sht.Select My excel file crashes when the macro runs (on Set sht), but only on certain devices. It doesn't throw any errors and tries to re-open in safe mode. Any advice would...

Anyone know why a VBA code might work, and then I save and close the file, and when I reopen it, the code doesn't work anymore? Previously the file was crashing whenever I tried to copy & paste code within the VBA module, and again when I would reopen the code would no longer work...

Good Morning, After closing a userform excel crash when I start a macro. Macros, before open userform, works very well. I try to set focus back to excel with ThisWorkbook.Application.Caption and also Private Sub UserForm_Terminate() Unload Me Sheets(“MySheet”).Activate End Sub Thanks

Hi, Is this a known problem that VBA stops working on workbook.close if it is trying to close a big file (1.7GB). My code basically only needs to open the file, copy all the information into a sheet on the workbook with the macro and then close the file. It does everything perfectly but on the...

Hello - I have a need to consolidate data from two worksheets in 2,700 workbooks into two worksheets in 1 big workbook. I have a piece of code that works well enough, but after a varying number of loops it crashes excel altogether. Sometimes it may make it through 10 files, others it may get...

Hi all, I'm a Mac user. I'm trying to create a PPT using VBA in Excel to copy a few tables and charts to different slides. However, whenever my script reaches PowerPoint commands, such as the one below, PowerPoint or Excel crash completely and close Set pptPres =...

I have an Excel file with a VBA project that had been working just fine until recently. I have finally tracked the problem but it does not make much sense: At one point, the code within the Excel file opens another file to get a value—this second file is provided by an outside third-party. When...

I'm new to excel VBA but I have now tested each part and they work correctly. What I'm trying to do is to simply delete the contents of a cell when the cells formula value is changed(no selection on entering key needed). The code is located under the sheet it runs in . Private Sub...

I created a small macro to copy new inputs to the end of a row of cells. The issue that I should've seen coming was that the last row where data was being pasted was in the range being watched, so Excel infinite-loop crashed. When I reopened the workbook the macro didn't respond to changes to...

I have a userform called "ProductDBForm" that uses a multipage to provide detailed data on all products in our range. I use a "Homepage" of sorts with a few images and a transparent box over each with a macro assigned to launch the relevant form or function. One of these is used to launch the...

once in a while when my excel runs this code it crashes and starts in recovery mode, does anyone know what might be happening? Private Sub bt_directorychange_Click() Dim fd As Office.FileDialog 'A variável "fd" irá corresponder á caixa de diálogo Set fd =...

I have a Userform which, when an item in a ComboBox is selected, brings up another form. This 2nd form is be filled in and closed, returning to the original form. When item A is selected, form A comes up and closes with no problem. When item B is selected, form B comes up and crashes the...

Hello everyone, I am working simultaneously with multiple instances of Excel, as this is a way to utilize more CPU and decrease calculation time per instance. Basically, there is one "Master" instance and several "Slave" instances. When I start the day, I first open the Master Instance, and...

Hi All! Hoping for some clever people to help out. I'm a VBA novice, but trying my best. Context: I have a large excel tool, with a lot of VBA included. Performance isn't perfect, but it's completely workable. I'm running Office 365 ProPlus 64 bit, other users running 32bit are also having...

I have a sheet with lot of code. Sometime it just stops working. Sometime it needs a full shut down and sometimes just time !! Anyone else had this issue ?

Hello. For a while I've been using the MsgBoxCB sub from Dan Elgaard (www.EXCELGAARD.dk) in order to have message boxes with custom button text. Up until now I have been using Excel 2007-2019 x32 and everything has been working perfectly. Recently I started testing my application on Excel 2016...

Hi, Please excuse the messy code - I'm entirely self taught and I keep tinkering with the code over time. I have this .xls workbook where I keep separate worksheets for individual share/options trades (file size is 7MB with lots of formulas). I trade overnight, so I have about 4 "sections" of...

I created a procedure that splits a file into a bunch of smaller workbooks and then emails them using outlook. I rolled this out to approximately 20 users. It works fine on everyone's PC except one person. On her machine the macro seems to run fine and then excel crashes without warning like it...