/VBA/Get all column names from excel vba

Get all column names from excel vba

Excel vba get column name from number

'For column number 256...

ColName = Split(Cells(, 256).Address, "$")(1)

Get all column names from excel vba

Sub datacollect()
Dim heading() As String
Dim i As Integer
i = -1
For Each x In Rows(1).Cells
    If x.Value = "" Then Exit For
    i = i + 1
    ReDim Preserve heading(i) As String
    heading(i) = x.Value
Next x
End Sub

Source: mrexcel.com

Similar codes

2 votes196 views1 answer
Excel vba check if string entirely numeric
VBA
0 vote189 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote184 views1 answer
Excel vba disable keyboard input
VBA
0 vote179 views1 answer
Open application from vbnet
VBA
0 vote204 views1 answer
Vbnet revrese the order of character in string
VBA
0 vote212 views1 answer
Vba character ascii code
VBA
6 votes198 views1 answer
Excel vba check if a string only contains alpha characters
VBA
0 vote235 views1 answer
Excel vba delete columns in range
VBA
0 vote194 views1 answer
Excel vba unmerge sheet
VBA
0 vote198 views1 answer
Vba run command
VBA