/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 vote129 views1 answer
Hello world vb.net
VBA
0 vote141 views1 answer
Open file dialog in vb.net
VBA
0 vote124 views1 answer
Excel vba disable copy paste
VBA
0 vote127 views1 answer
Vbs exec hidden
VBA
0 vote125 views1 answer
Vba code to select image in sheet
VBA
5 votes143 views1 answer
Excel vba right word from Long Integer
VBA
1 vote118 views1 answer
Vba compile error object required
VBA
0 vote141 views1 answer
Excel vba textbox forecolor disabled
VBA
1 vote137 views1 answer
Excel vba array remove first
VBA
0 vote124 views1 answer
Enter into cells data grid view
VBA