ordinary pasting results in text-to-columns
If I select a whole cell and paste it normally, I do ok, but if I have copied anything else either in Excel or outside it and then paste, it behaves like a text-to-columns command. I tried pasting special/values and that doesn't help. I actually did a text-to-columns exercise on purpose yesterday, and this has only been happening since then. I feel like I am stuck in text-to-columns mode. What gives?
This was solved in an earlier thread. Thanks to Jim Rech for finding the answer - it works!
http://support.microsoft.com/default...b;en-us;127132
I have marked the thread as solved for you. In future, go to Thread tools -> Mark thread as solved.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks