on error resume next

  1. Johnny Thunder

    VBA - Add "On Error Resume Next" to my working code"

    Hi guys, for the life of me I can't figure out how to add an "On Error Resume Next" line into my working code. I have a macro that opens files in a directory and if it finds a specific tab name it deletes it, in the event the tab does not exist I want it to close the file and open the next...
  2. S

    Excel/VBA: Skip error and continue w/ code execution

    First, thanks a million to all who are here to share their expertise and to spend their time to solve the coding related problems of others. You have no clue how much you've helped me so far w/ my job. Problem: My macro doesn't do what I want. I have an excel file w/ multiple columns. What I...
  3. N

    Delete Row IF condition is met, IF NOT proceed to next condition etc

    Hi everyone, I've been googling my heart out but still haven't found the VBA code / solution I am after. Let's say I've got 2 spreadsheets named spreadsheet1 and spreadsheet2. In spreadsheet1 there are hundreds of rows with relevant data and I have already turned the autofilter on. The unique...
    • nremf
    • Thread
    • cross reference delete rows vba look up data on error resume next
    • Replies: 4
    • Forum: Excel Questions
  4. D

    Option Explicit

    Hi there,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am working on a template for a report, and I got stuck with something.<o:p></o:p> <o:p> </o:p> I have the function "Option Explicit" activated, and the last of the macros must search...

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