/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 vote134 views1 answer
Vba open report
VBA
0 vote137 views1 answer
Returns an array from function vba
VBA
0 vote154 views2 answers
S yyyy-MM-dd em vb net
VBA
0 vote186 views1 answer
Find control with name vb
VBA
5 votes142 views1 answer
Xl vba double quotes in string literal
VBA
0 vote95 views1 answer
Vbide vbproject reference
VBA
0 vote145 views1 answer
Check if program is running vbnet
VBA
0 vote171 views1 answer
Vbnet check if string is only letters
VBA
0 vote137 views1 answer
Vb net dgv doesn't keep currency format
VBA
1 vote125 views1 answer
Vba compile error object required
VBA