Results 1 to 2 of 2

Thread: Critical Error: Odd Behavior on This particular Line all day

  1. #1

    Critical Error: Odd Behavior on This particular Line all day

    I have a procedure that has worked fine until today. Stepping through the entire procedure works properly everytime. Running it from start to finish however has given me a host of errors. I have not noted them as I have been looking for errors. But now this one is one I have never seen.

    vba run-time error '-2147221080 (800401a8)': automation error

    It is on a simple loop of all sheets w/in a particular workbook:
    For Each wsnSource In wbSource.Worksheets
    my site:
    was built w/ a majority of the assistance from the board members here... thanks VBAX.

    Just because I see something, doesn't mean that what's actually happening is what I see.

    You don't get from 0-90 by standing still!

  2. #2
    Knowledge Base Approver VBAX Master Oorang's Avatar
    Jan 2007
    erm perhaps post a bit more code?

    Keep Our Board Clean!
    • Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
    • Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts