/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

3 votes408 views1 answer
Vba continue for each loop
VBA
0 vote374 views1 answer
For each item in folder outlook vba
VBA
0 vote481 views1 answer
Wpf dark title bar
VBA
1 vote362 views1 answer
Vba delete file
VBA
0 vote346 views1 answer
Vba format currency
VBA
5 votes406 views2 answers
Excel vba write to the windows registry
VBA
18 votes523 views3 answers
Excel-vba make integer
VBA
0 vote369 views1 answer
Delete rows in excel vba code
VBA
-1 vote345 views2 answers
How close excel through visual basic
VBA
0 vote343 views1 answer
Open application from vbnet
VBA