Can i say ive sat here for about ten minutes thinking and thats a discrace of a responce, VERY RUDE dont you agree? Address Dennis you know he is second language English and is from Sweeden, thats a little over the top top dont you think??
Dennis did not post a question it was a post to offer help as many of i do, a FREE GIVE AWAY, no where did Dennis say hes right or this is the ONLY solution
Mark, how would you like it if itagged every single post of your and did this and distroyed you work and kind offer of help - this would be fair and reasonable would it not?
Sometimes you have to take the good with the bad. All in here are not experts and those of us that are not, appreciate all the help we can get. Sad the competition is so high, because so many are in need and interested in learning anything they can. Dan
Do what you most - but Mark has done this before he ont answer ive tried before he just hide before has ignored PM and from pals of mine to. Iv had this now 5 or 6 times, just his way. People do notice and i get loads of Pm and emails on this subject, and all sorts
Ive had enough too, ill post in questions forumn and see ill address ALL MVP as you know i know all of them and se if they can add.
What else can i do? I get so many email saying guys ive never hurd of showing support towards me and and i thank them kindly from their warm comments but some [not many] MVP do cross the line
I was merely prompting Dennis to look at Excel's built-in functionality.
A single VBA statement can be created by simply by using the macro recorder...
Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
:=Array(1, 1), DecimalSeparator:=",", ThousandsSeparator:="." This message was edited by Mark W. on 2002-11-14 09:51