/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 vote143 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote151 views1 answer
Vba boolean to string
VBA
0 vote152 views1 answer
VBA Loop to range
VBA
0 vote145 views1 answer
Openfiledialog specific folder
VBA
0 vote156 views1 answer
Pivot data source not accepting table named range vba
VBA
0 vote142 views1 answer
Excel vba disable copy paste
VBA
5 votes159 views1 answer
Excel vba low word from Long Integer
VBA
0 vote138 views1 answer
Vba test optional argument
VBA
0 vote141 views1 answer
Change "location" of binding navigator vb
VBA
0 vote154 views1 answer
Vba array dimensions
VBA