/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 vote345 views1 answer
Vba get workbook name
VBA
1 vote353 views1 answer
Vba loop through files in folder
VBA
0 vote360 views1 answer
Vba character ascii code
VBA
0 vote342 views1 answer
Excel vba calculate
VBA
0 vote360 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote348 views1 answer
Vba table header name
VBA
0 vote353 views1 answer
Excel vba protect worksheet without password
VBA
0 vote343 views1 answer
Excel vba remove formatting from cell
VBA
0 vote388 views1 answer
Vba userform textbox wrap text
VBA
1 vote321 views1 answer
Vba declare api 64 bit 32 bit
VBA