/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 vote176 views1 answer
Pivot data source not accepting table named range vba
VBA
0 vote164 views1 answer
Enable macros on opening workbook vba
VBA
0 vote184 views1 answer
Vba clear collection
VBA
0 vote177 views2 answers
Excel vba number format file size
VBA
0 vote161 views1 answer
Afficher un message d'erreur vba
VBA
5 votes183 views1 answer
Excel vba right word from Long Integer
VBA
0 vote190 views1 answer
Vba multiple optional arguments
VBA
1 vote174 views1 answer
Excel vba unload userform
VBA
20 votes319 views1 answer
Excel vba recursive example factorial function
VBA
0 vote175 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA