intermittent failure

  1. C

    Script crashes - sometimes

    I have a script I have been using for years, but at one point it started crashing on me, but only sometimes. Usually it is when I open it fresh. If I run a few of the other macros in the workbook to sort of "prime the pump," it works just fine. I am using Excel 2016 for Mac. I'm trying to copy a...
  2. K

    Error 1004 SaveAs Method - Works 95% of the time.

    Hello, In general, the following lines of code work: ActiveWorkbook.SaveAs Filename:=mstrBARRA_FILE_PATH & astrAccountName(intAccountCount) & "\" & _ astrAccountName(intAccountCount) & ".por", _ FileFormat:=-4158...
  3. K

    Loop stopped working: Selection.End(xlDown).Select

    I have a loop in a macro that seems to have stopped working. This part of the macro, and the data I'm using to test the macro, have not changed since the last time I tested it, 2-3 weeks ago. All changes made to the macro take place after this part is complete. (I was trying to check something...
    • kdorian
    • Thread
    • intermittent failure loop from the bottom xldown
    • Replies: 0
    • Forum: Excel Questions

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