I search the internet but found no solution for this. The only solution I found was for the current workbook copy paste, but if you copy some text specially formatted text from other workbooks or from Internet explorer, it just won't work. Please help. BTW i'm using Excel 2007, TIA.