Thanks for all your replies.
I have tried two of Ritchie's solutions and they work fine on a new worksheet, however I have saved the macros to a personal workbook in an alternative startup location on our Network. I have imported a text file and tried to run them on that and it doesn't work!
Do you have any idea why it doesn't work?
I noticed that you used 'With Sheet1'
Because I have imported from a text file I have to rename the sheet to Sheet1, I don't know if this affects anything!
Can you help me please?