-
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:
[VBA]
For Each wsnSource In wbSource.Worksheets
[/VBA]
my site: www.ecboardco.com
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!
-
erm perhaps post a bit more code?
Cordially,
Aaron
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
-
Forum Rules