/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 vote229 views1 answer
Vba array of integers
VBA
0 vote225 views1 answer
VBA OR vb6 find OR replace string from the end
VBA
0 vote238 views1 answer
Vbscript check if string contains
VBA
3 votes214 views1 answer
Vba make long from two shorts
VBA
15 votes447 views1 answer
Excel vba wait
VBA
0 vote267 views1 answer
Vba excel parser xml
VBA
5 votes243 views1 answer
Excel vba first byte from INTEGER
VBA
0 vote231 views1 answer
Excel vba copy range with filter
VBA
0 vote202 views1 answer
Change "location" of binding navigator vb
VBA
1 vote229 views1 answer
Excel how to format bytes as KB, MB, GB
VBA