/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

0 vote183 views1 answer
Excel vba formatconditions positive
VBA
0 vote172 views1 answer
Excel vba move down to next visible cell
VBA
0 vote176 views1 answer
Vba word open document read only
VBA
1 vote167 views1 answer
Excel vba last row of range
VBA
5 votes214 views1 answer
Excel vba get low byte from INTEGER
VBA
0 vote180 views1 answer
Selecttoken em vbnet e json
VBA
0 vote180 views1 answer
How to set location and size of new from vb
VBA
1 vote168 views1 answer
Excel vba make cell visible
VBA
0 vote154 views1 answer
Excel vba concatenate range
VBA
0 vote174 views1 answer
Vba loop through table
VBA