>I have not gotten to iterating thru the range. The error trap is on trying to create an object on a non existant range. Maybe your are right, the range object may have some reference that is keeping the form from closing. Should I not let the error event handle this?
Without knowing all the details, I'd have to say, in general, yes. If you do, then you'll have to have some mechanism to reference the Excel object (most likely as a property of the class). If the solution is to then shut down the server object, it'd be pretty straight forward to do it from there.
George
Ubi caritas et amor, deus ibi est