/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 vote233 views1 answer
Excel vba delete folder
VBA
0 vote236 views1 answer
Not allow form to be resized
VBA
15 votes460 views1 answer
Excel vba wait
VBA
1 vote216 views1 answer
Vba compile error object required
VBA
0 vote250 views1 answer
Return na vba
VBA
0 vote264 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote226 views1 answer
Remove last 8 characters from string vb
VBA
2 votes223 views2 answers
Vba code to remove duplicates from a column
VBA
7 votes227 views1 answer
Vba array declaration
VBA
0 vote216 views1 answer
Vb window.minimize
VBA