crashing

  1. R

    Set Lrow by dialog box? & Loop batch size limit

    I am compiling a register of projects and have been using VBA to Loop through 25-40 files in a batch. As the list gets longer I have been manually changing this in the macro text. 1) Does anyone know if i can use a dialog box to set the Lrow, to add to bottom of list? (So I can't forget to...
  2. D

    VBModeless UserForm Closing/Crashing Excel

    Hi, I have a Userform which opens as "vbModeless," it contains a series of buttons to open more Userforms that all open as "vbModeless." Very simple, but randomly some of the files will immediately close when selecting one of the buttons contained on the first opened form. If I remove the...
  3. J

    Microsoft Excel is not Working - Crashes on VBA SaveAs

    For some reason, my excel keeps crashing every time it runs over the saveas section of my code. I've written the code two different ways, and both crashes the excel. The line of code doesn't always crash excel, it is usually the second or third time running the code that it happens. Does anyone...
  4. RJSIGKITS

    Continuous crashing - How do I clean up excessive data?

    Hi guys. I have an extremely large excel workbook that we use to do all of our client quotes, and as it's a document that has evolved over the years, there's loads of data and 'stuff' on it like Named ranges, references etc etc that must surely be causing my continuous crashing issues. Trouble...
  5. I

    Windows 10 seems to be crashing VBA Macro whilst running

    Hello everyone. I currently run a VBA Macro that can take several hours. Previously I have never had a problem but I have just updated to Windows 10, and now when I come back to my PC I find that Excel has crashed and I am presented with recovery files. It seems that W10 is doing something...
  6. D

    VBA code to create PDFs causing Excel to crash immediately without any hang

    Hi, I have a VBA procedure that loops through each file in a directory and does the following: 1. Opens the file 2. Selects 2 sheets 3. Exports those sheets to a PDF Excel is crashing during this process at random. I.e., one time it can crash after 6 PDF files created, and another after 10...
  7. B

    Sort function crashing now in new 365, help?

    Hello I am new to VBA and Excel so please excuse my ignorance on some terminology. My boss uses Excel 7 and I use 365, his code that he has used for 10 years for the Sort function is as follows. Range("A1:A14").Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlYes or Range("E1", "F" &...
  8. M

    Excel crashes on save or copy

    I have a 6 MB xlsm workbook with Power Query (17 queries) and no VBA. Everything used to work propertly for years. I made some changes to the queries and worksheets yesterday and since then, when I try to save the workbook or press CTRL+C, the workbook crashes. No error message, no warning...
  9. B

    VBA: Excel has stopped working

    Hi All, have been running a very simple macro for the last few months which very simple pulls in a file from another location and pastes some data. It then Fetches another file and at this point it seems to cause excel to crash and the "excel has stopped working" error. This error has only...
  10. J

    VBA, Excel keeps crashing

    As I am stepping through this section of the code it works but by the time it gets to a certain row it crashes my excel. Is there a better way to write to my excel sheet? It writes a value cell by cell, not sure why its crashing! For j = 1 To nCols If fromTop Then writeVal = arr(i...
  11. T

    [VBA] Vlookup sometimes crashing Excel

    Is it possible to replace the vlookup function below by something else? This solution is crashing the excel very often. Dim rngS As Range Set rngS = Range("S11:S" & END_Row - 2) With rngS .FormulaR1C1 = "=VLOOKUP(RC[17],'\\ad.igt.com\igt\TEAMS\ TOOL_ADMIN\###IAT...
  12. D

    Excel crashing on Copy / Paste

    Hello All, A workbook I developed is crashing on a vanilla copy/paste. At bit of background: * No VBA * Issue happens whether I use toolbar or shortcut keys * I have tried: (i) copying to another workbook; (ii) removing conditional formatting; (iii) unhiding and ungrouping rows and columns...
  13. F

    Excel 2013 Locking Up When Trying To _Print

    Hey all, I have this strange issue with some of my Excel files. Whenever I try to print from excel, it will lock up when selecting the "Print" section under "File." Once it's at the printer settings, it will say "Looking for printers" at the printer selection menu and the entire excel sheet...
  14. C

    Excel no longer likes filters

    This is kind of a vague question. I have been using Microsoft Office Professional Plus 2013 for however long. This is a work computer and updated and patched regularly. As of a couple of weeks ago, Excel will stop responding probably 60% of the time if I try to use a filter. Even on small...
  15. G

    Why does Excel keep crashing when I click on "Apply borders to this selection" icon

    Any ideas anyone? Thanks for your thoughts.
  16. T

    Excel crashes when enabling macros

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

    Having random trouble with a line of VBA code

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

    Spreadsheet Frequently Crashes on Close

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

    PowerPoint Chart Copy Closing Mid-Format Procedure

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

    VLOOKUP across 700K rows in 32-bit Excel

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

Some videos you may like

This Week's Hot Topics

Top