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