thats my biggest problem, if I could fix the error I would, but it's not in my code, it is in the files my codes read. I have a variable x defined, and there are some variants of that x missing in the files being read. I think if I use
and make it skip that variable x and move onto the next one my problem will be solved. I just don't know how to make it go back to a certain line number. For the most part, this error doesn't arise, it just happens that for this data, the last 3 days of the month encountered it.
edit ***
I tried using your logic. I put the on error resume next before the line i want it to resume at and on error goto 0 after the point where I'm getting the error. Does it sound like I'm using the syntax properly?
Bookmarks