I don't think it's that easy - I have managed to workaround this one
in the past. Either post a small sample of the text file  and the whole
macro here along with how you want it to finish up, or send a copy of
the spreadsheet, with the macro in it, and the data as it is about to
be saved, directly to me (pascaldaulton at tesco dot net).