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


--
NiallC
------------------------------------------------------------------------
NiallC's Profile: http://www.excelforum.com/member.php...o&userid=25948
View this thread: http://www.excelforum.com/showthread...hreadid=393246