VBA to set Text-to-columns function back to default

**anrichards22** · 06-17-2013, 12:29 PM

Is it possible for VBA to set the Text-to-columns function back to its default values? (i.e Tab delimited)

Any assistance appreciated.

Thanks!

**Norie** · 06-17-2013, 12:33 PM

There isn't really a default, Excel looks at the data and decides whether it's fixed length or delimited and sets the options accordingly.

**anrichards22** · 06-17-2013, 12:38 PM

When I choose the delimiter Excel stores that value so next time I paste stuff into Excel it uses that as the delimiter.
For example if I use "Space" as the delimiter, next time I paste something into excel it pastes using "Space" as a delimiter...even if that is NOT what I want.
I have to run a dummy text-to-columns to get it back to Tab delimited.
It is a mega pain in the backside!