not responding

  1. A

    Worksheet_Change with Named Ranges not Responding

    I created a worksheet with the following code to cause a macro to execute when the values in certain cells change: Private Sub Worksheet_Change(ByVal Target As Range) 'Check to see that we have enabled auto macro updating If Range("Report_Type_Auto_Run_Macros") = "ENABLED" Then...
    • Arty Choke
    • Thread
    • formula calculation named range not responding problem worksheet_change
    • Replies: 5
    • Forum: Excel Questions
  2. A

    Worksheet_Change named range problem

    I have a spreadsheet that runs a macro when a change happens within either of two named ranges. The original code is as follows: Private Sub Worksheet_Change(ByVal Target As Range) 'Check to see that we have enabled auto macro updating If Range("Report_Type_Auto_Run_Macros") =...
  3. K

    Excel 2007 Extreme Delay When Deleting Data In Rows

    Problem: We have some rather large excel spreadsheets (142,000 rows, 190 columns) and some users that need to delete the data from rows of cells 5,000 rows + at a time. When doing this machines jump in CPU, Excel goes "not responding" and on average comes back to life 1 minute 45 seconds after...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top