/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 vote309 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote310 views1 answer
Excel vba named range exists
VBA
0 vote287 views1 answer
Xlbycolumns is not declared
VBA
0 vote292 views1 answer
VBA is form loaded
VBA
4 votes283 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote267 views1 answer
Vbide vbproject reference
VBA
0 vote299 views1 answer
Vba parameter adodb null value
VBA
1 vote290 views1 answer
Excel vba saveas force overwrite
VBA
0 vote284 views1 answer
Excel vba delete folder
VBA
0 vote272 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA