Breaking News: Grepper is joining You.com. Read the official announcement!

text to column in excel using vba

Add Answer

Drab Donkey answered on June 7, 2022 Popularity 5/10 Helpfulness 5/10

Contents

answer text to column in excel using vba

More Related Answers

excel vba write string to text file

in Excel using VBA, how do you change a cells FONT

excel vba convert cells(1,1) into A1 and vice versa

excel vba copy entire sheet paste values

excel vba function to convert column number to letter

excel vba convert text YYYYMMDD to date

vba set cell value

pandas write to excel

excel vba column letter

python script to write dataframe on excel

vba get cell value

excel vba column letter to number

excel vba cell on change

excel vba Column Name from Column Number

excel vba split string into cells

c# get excel column number from letter

excel vba split string into cells

how to convert csv to excel in python

python script to write dataframe on excel

excel vba scroll to cell

convert int to excel column name

in Excel using VBA, how do you change a cells BOLD setting ON

excel write column

pandas with txt to excel

pandas write to excel

python script to write dataframe on excel

Set the font name in Excel XLS using VBA

c# convert excel column index to letter

excel convert the data type in cell

text to column in excel using vba

Comment

0

Private Sub CommandButton1_Click()
    Dim rng As Range
    Dim sh As Worksheet

    Set sh = Worksheets("Sheet2")
    With sh
        Set rng = .[C7]
        Set rng = .Range(rng, .Cells(.Rows.Count, rng.Column).End(xlUp))

        rng.TextToColumns Destination:=rng, DataType:=xlDelimited, _
        TextQualifier:=xlDoubleQuote,  _
        ConsecutiveDelimiter:=False, _
        Tab:=False, _
        Semicolon:=False, _
        Comma:=True, 
        Space:=False, 
        Other:=False, _
        FieldInfo:=Array(Array(1, xlGeneralFormat), Array(2, xlGeneralFormat), Array(3, xlGeneralFormat)), _
        TrailingMinusNumbers:=True
    End With
End Sub

Popularity 5/10 Helpfulness 5/10 Language vb

Source: stackoverflow.com

Tags: excel text-to-column using vba

Share

Link to this answer
Share Copy Link

Drab Donkey

Contributed on Jun 07 2022

Drab Donkey

0 Answers Avg Quality 2/10

X

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

X

Grepper Account Login Required

Oops, You will need to install Grepper and log-in to perform this action.

Install Grepper Here