/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

15 votes435 views1 answer
Excel vba wait
VBA
0 vote216 views1 answer
Loop through lines in text file vb net
VBA
25 votes495 views2 answers
Excel vba folder exist
VBA
0 vote224 views1 answer
Power query M substract minimum value of column -dax
VBA
0 vote210 views1 answer
Excel vba linter
VBA
0 vote214 views1 answer
Vb test if reference is null
VBA
0 vote200 views1 answer
Vba find last column in a row with data
VBA
6 votes230 views1 answer
Excel vba isalpha
VBA
1 vote202 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote210 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA