/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 vote286 views1 answer
Excel vba hide columns
VBA
0 vote312 views2 answers
Vba remove line breaks
VBA
1 vote313 views1 answer
Vbs run
VBA
8 votes360 views1 answer
Vba make integer
VBA
0 vote311 views1 answer
Vbnet check if string is only numbers
VBA
0 vote320 views1 answer
Send webhook vbscript
VBA
0 vote313 views1 answer
VB get external IP address
VBA
0 vote336 views1 answer
Regex numeric digits
VBA
0 vote289 views1 answer
Putting marquee in vb.net
VBA
0 vote314 views2 answers
How to concatenate more than 40 lines in vba
VBA