ignore error

  1. M

    Ignoring Worksheet Copy Error

    Hi, I obtained this code for get individual worksheet sizes inside the workbook but it produces errors when attempting to copy a worksheet with vba code defining a global variable such as Private timerDictionary As Scripting.Dictionary This is the code I used to get individual size of each...
  2. N

    VBA or Way to Ignore "Negative or Zero Values Cannot Be Plotted on a Logarithmic" scale

    Good morning, I have a sheet that has pivot charts connected to an analysis tab. The analysis tab converts qualitative data (<10) to numbers which are then charted on a Log-10 scale. Every time I refresh or use the Timeline slicer, the "Negative or Zero Values Cannot Be Plotted on a Logarithmic...
  3. A

    Sum Every nth Cell -Ignoring Errors in Range

    This has been asked before, answered and solved here: https://www.mrexcel.com/forum/excel-questions/503738-sum-every-other-cell-ignoring-errors-range.html The reason I'm revisiting it, is because I don't understand enough about how these formulas work. The solution given to this user worked for...
  4. C

    Green flags and other people viewing my workbook...

    I know that you can remove the green flags so that you cannot see them by changing "tools>options>error checking>unticking enable error checking in background", but I am looking for a way to 'Ignore Error' on all cells at once that have a Green flag so that when another user on a different PC...
  5. T

    Handle Error Code 91 and Move on to Next Operation

    Hello, Help with this would be much appreciated. I wrote a program that seeks out a specific string and modifies the format of it's cell once it is found. Sometimes the string will exist on the sheet and sometimes it won't. I need the program to keep running and do its job if the string isn't...

Watch MrExcel Video

This Week's Hot Topics

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
Top