The following macro was kindly written by Jerry Beaucaire and works wonderfully.

However, I now find that I am getting files, which I have to change, where the detail for changing is neither on the 5th or 6th but is on the 4tth and in one case the 7th. Therefore is it possible the macro can be adapted so it asks the user to enter the number of the line to be changed and the macro runs and gets that line of information. Many thanks.

Please Login or Register  to view this content.