Re: [ExcelVBA] TextToColumns?

 

David,
 
There is way too much code to post and I am not at all certain what part of the code creates the problem, but I thought someone might have experienced the same problem.
 
Thanks,
David


________________________________
From: David Grugeon <yahoo@grugeon.com.au>
To: ExcelVBA@yahoogroups.com
Sent: Monday, May 7, 2012 7:54 PM
Subject: RE: [ExcelVBA] TextToColumns?


 

Hi David

Unless we see the code we are really not in a position to understand what it
is doing. Could you paste the relevant code in a response email?

Best Regards
David Grugeon
Excel VBA Group Moderator

-----Original Message-----
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
Of David
Sent: Tuesday, 8 May 2012 4:40 AM
To: ExcelVBA@yahoogroups.com
Subject: [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

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

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

----------------------------------Yahoo! Groups Links

[Non-text portions of this message have been removed]

__._,_.___

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

Messages in this topic (6)

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

.

__,_._,___