TextToColumns has "sticky" settings.
So, yes, pasting something like that will be split up based on your last
TextToColumns operation.
Just reset the TextToColumns settings and everything should work as you
want.
It's a "feature". :)
On Mon, May 7, 2012 at 11:40 AM, David <who1012000@yahoo.com> wrote:
>
> After run some code, if I simply Ctrl+C something and CTRl+V, the formula
> ends up in multple cells.
>
> I am not really certain that it is caused by part of the code performing a
> TestToColumns, but seems a likely suspect.
>
> I can not stop this unless I shut Excel down and restart it.
>
> Any Ideas? Can I add a line of code to stop this from happening, maybe
> just before exiting the code?
>
> I looked through the parameters, most of which are "False" by default, but
> maybe after running the code I would have to set them all again to False?
>
> I am not at all certain that it is TextToColumns at fault. But I thought
> maybe someone else had run into this?
>
> Using V2003.
>
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar