unresponsive

  1. A

    Excel unresponsive when running a macro

    Hi all, When I run a macro Excel becomes unresponsive - hope you could help. The code is made to remove all styles in the document. I suspect that either I have an error in a code, forgot one of the 101 VBA steps or perhaps it is just too much to process for the program and some modification...
  2. L

    Ambiguous VBA - excel file unresponsive

    Hello everyone! I've made THE HUGE mistake saved file with ambiguous vba-s PLEASE PLEASE PLEASE is there a way to delete one of them somehow? excel works fine but exactly that file that contains that vba is not responding! PLEASE ANY IDEAS? PLEASE HELP!
  3. X

    Inserting copied row code causes Excel to hang (swirly blue circle)

    Hello one and all, I've inherited a Macro enabled spreadsheet I'm trying to make work on Excel 2013, it works OK on Excel 2007 and below. Problem: Manually selecting, copying and inserting a row works OK; however, when running the code below on later versions of Office it causes Excel to stop...
  4. J

    Essbase Unresponsive when ZoomingIn

    I have a rather lengthy code that I won't post unless requested to because I honestly don't know which part to post (where the code is going wrong). Basically I have a few procedures that cycle through each row of a table that specifies certain retrieve criteria and use the essbase commands to...
  5. D

    Ribbon Frozen (Not Responding)

    I've run into a problem recently. Sometimes when I double-click to open a file, the ribbon stops responding, or is frozen. None of the buttons respond to the mouse (can't click, don't highlight when the pointer hovers, etc.). I can still edit the contents of the file, but the only way to save...
  6. D

    Why does Excel run slowly / unresponsively AFTER this macro has completed successfully?

    I have a fairly large macro shown below which basically open a Word template, copies some named ranges in then completes a mail merge merging data from the workbook into the Word template. Finally it calls a simple Word macro to insert a table of contents into the document. It does a few other...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top