/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

6 votes177 views1 answer
Excel vba isalpha
VBA
0 vote152 views1 answer
Vbnet hex to binary
VBA
1 vote160 views1 answer
Set font for ms chart vb.net
VBA
0 vote185 views1 answer
Wpf dark title bar
VBA
0 vote155 views1 answer
Reference to a non-shared member requires an object reference
VBA
0 vote114 views1 answer
Vbide vbproject reference
VBA
0 vote151 views1 answer
Vbnet get file name from path
VBA
1 vote152 views1 answer
Change the first item in a queue vb.net
VBA
3 votes169 views1 answer
Excel vba get the workbook full filename with path
VBA
0 vote182 views1 answer
Excel vba move down to next visible cell
VBA