/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 vote293 views1 answer
Excel web scraping
VBA
0 vote254 views1 answer
Vba first line of string
VBA
1 vote268 views1 answer
Vba optional
VBA
3 votes264 views1 answer
Vba request json
VBA
0 vote293 views1 answer
Excel vba set cell value to empty
VBA
0 vote300 views1 answer
Vba integer to double
VBA
1 vote250 views1 answer
Excel vba hide zero values
VBA
0 vote261 views1 answer
Vb streamreader
VBA
0 vote393 views1 answer
Amd64 vs arm64 linux
VBA
0 vote277 views1 answer
Vba get workbook name
VBA