Getting interesting error message

[greaseman]

[RESOLVED] Getting interesting error message

I have an Access project that when it starts, lets you pick a folder and a file to open as input (done with VBA code), and that works beautifully. My project then processes the opened file and that works fine also. However, when I run the project a second time, pick another file (with the same format), my project then dies on me. If I get completely out of my project and thenre-enter it, it runs fine. I've enclosed a screenshot of the error I'm getting.

Any help is greatly appreciated. And yes, I did a search on this and several other forums as well as on Microsoft's site and could not find anything related to the error I'm getting.

 

[ScottGem]

What line of code is causing the problem?

 

[greaseman]

I got it figured out. It was in the way I was selecting my rows and cells and formatting them. For some reason, if I did not exit completely from my project, something was getting "stuck" i my code, but as soon as I altered my code to use the "SELECT" for each cell, all worked!