Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #54.9K
|
I have tried as many different ways to do a sort as I can think of... I keep getting application defined errors. Here is my code: With ActiveSheet .Range("a:a").Select n = Application.CountA(Selection) .Columns("B:B").Select Application.CutCopyMode = False Selection.TextToColumns Destination:=Range("B1"), DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=False, Semicolon:=False, Comma:=False, Space:=True, Other:=False, FieldInfo:=Array(1, 1), TrailingMinusNumbers:=True (THE …
|