[ExcelVBA] TextToColumns?

 

Hello Group,

Hope everyone is having a good day.

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.

Thanks,
David

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 5

Visit Your Group

----------------------------------
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

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___