/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 vote340 views2 answers
Excel vba copy paste after last row
VBA
0 vote406 views2 answers
Excel vba store array and write to sheet
VBA
1 vote375 views1 answer
Vba login website
VBA
6 votes373 views1 answer
Excel vba get the path of current workbook
VBA
0 vote328 views1 answer
Vba declare 64-bit ptrsafe
VBA
0 vote332 views1 answer
Vba copy file
VBA
0 vote324 views1 answer
Vba line feed
VBA
0 vote318 views1 answer
Vba sheet visible
VBA
0 vote354 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote358 views4 answers
Vgrive,deb
VBA