Originally Posted by
NiallC
Hi All,
Quick question about Text to Columns function/pasting data. Basically i've created a Macro which involves using Text to Columns to delimit some data. The macro is associated with a command button and is working fine.
The problem is that when I close and reopen the worksheet with the command button in it and paste my data in, it automatically delimits it before I run the macro. This renders the macro useless as its dependant on the data being pasted in, in a certain format.
The only way I can get the sheet to accept the pasted data as normal (not delimit it automatically) is to close down excel completely and then reopen my worksheet. Is there a way to 'reset' the worksheet before I paste the data in, or some other way around this?
Any help would be greatly appreciated!!
Niall
Bookmarks