intermittent failure

  1. 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...
  2. 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...

Some videos you may like

This Week's Hot Topics

Top