Placement of a particular line of code

Dear all,

I have some code which imports a large volume of text file data into Excel, within which I have a 'find and replace' line. Originally I had this placed within a loop, so that it checked the whole worksheet after every line imported - this was obviously a mistake and caused the code to take ages to run. I thought I'd replace the line of code in question to the end of the code, so that it 'finds and replaces' only once. However, I've tried placing the following line of code at numerous positions near the end of the code, but haven't been able to get it to actually perform the find and replace part (i.e. char(13) remains after the code has finished - I do however get an 'input past end of file' error, which may be partly to blame, although all the data does appear to import...?):

Please Login or Register  to view this content.

The original code is:

Please Login or Register  to view this content.

Does anyone have any ideas?

Many thanks,
smurray444

The Chr(13) shouldn't be a problem - it's an exotic character which I hope to remove.

The rest of the code works fine as far as I can tell. It's just that whilst the 'find and replace' bit worked when I had it doing it after every row imported (which would've taken ~200 days to complete!), it no longer seems to work when I ask it to do one big sweep at the end of the entire import (although there is no error relating to it when the code runs, it's just that the exotic character remains!).

Hope someone is able to offer some advice.

Thanks again
smurray444

The symbol is a Unix-based carriage return character (appears as a question mark in a box in Excel). I've tried pasting it in, but it doesn't display (because it's not a standard character I guess).