/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 vote317 views1 answer
Excel delete ever other vba
VBA
0 vote280 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote257 views1 answer
Excel vba concatenate range
VBA
1 vote245 views1 answer
Vba exit do while
VBA
0 vote307 views1 answer
Vba is integer
VBA
1 vote282 views1 answer
If inputbox cancel vba
VBA
0 vote293 views1 answer
How to use if condition in time vba
VBA
0 vote292 views1 answer
Limit combobox to list vba
VBA
0 vote285 views1 answer
How to get the value of optionbutton in vba
VBA
0 vote279 views1 answer
Excel vba disable mouse click
VBA