ItalianPlatinum
Well-known Member
- Joined
- Mar 23, 2017
- Messages
- 733
- Office Version
- 2021
- 2019
- 2016
- 2010
- 2007
- Platform
- Windows
Is there an easy way for me to remove this "select" option i tried using With sheet and defining the workbook and sheet together but then i mess up my comma delimited. Anyone able to assist? Sheet is called "data"
VBA Code:
Sub CommaDelimited()
Columns("A:A").Select
Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _
Semicolon:=False, Comma:=True, Space:=False, Other:=False, FieldInfo _
:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1), _
Array(7, 1), Array(8, 2)), TrailingMinusNumbers:=True
End Sub