/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 vote99 views1 answer
How to sort datagridview in vb.net
VBA
1 vote154 views1 answer
How to put a gridpain in a vbox
VBA
0 vote176 views1 answer
Excel vba move down to next visible cell
VBA
0 vote161 views1 answer
Prive sub enter clicked vb
VBA
0 vote147 views1 answer
How to extract a file from an ISO:
VBA
0 vote145 views1 answer
Vba code for cutoff time
VBA
0 vote153 views1 answer
Excel R1C1 mode
VBA
0 vote158 views1 answer
Vbscript Trim
VBA
0 vote162 views1 answer
Find database connection string vb
VBA
31 votes265 views1 answer
Excel-vba how to convert a column number into an excel column
VBA