/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 vote170 views1 answer
Vba listbox remove all items
VBA
0 vote175 views1 answer
Thread sleep vb
VBA
0 vote158 views1 answer
Vba code to select image in sheet
VBA
0 vote148 views1 answer
Vba text to general
VBA
0 vote162 views1 answer
WGET FTP
VBA
3 votes171 views1 answer
Vba http request json
VBA
5 votes175 views1 answer
Excel vba right word from Long Integer
VBA
0 vote151 views1 answer
Excel vba concatenate range
VBA
0 vote174 views1 answer
Vba table header name
VBA
3 votes165 views1 answer
Vba request json
VBA