MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Text-to-columns problem

Posted by Chris - Tate Gallery on October 29, 2001 3:03 AM

I use a number of macros that I've set up which use the text-to-columns function regularly.

After using this (and also on its own, not necessarily within a macro) I find that if I try to copy/paste from an external application into Excel, the resulting paste comes in as CSV garbled info, for example splitting a number up into 2 seperate columns as if its still trying to text-to-column the info.

I'm wondering if there's an easy way to clear the clipboard or something as at the moment I have to keep rebooting to stop it thinking I want text-to-columned info.

Many thanks...

Posted by JAF on October 29, 2001 3:23 AM

Application.CutCopyMode = False
should clear the clipboard and prevent your problem.