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...?):
The original code is:
Does anyone have any ideas?
Many thanks,
smurray444
Bookmarks