/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

5 votes147 views1 answer
Vlookup vba
VBA
0 vote191 views1 answer
Vba text to general
VBA
0 vote217 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote221 views1 answer
Vba round to 2 decimals
VBA
0 vote202 views1 answer
Excel vba disable mouse click
VBA
8 votes474 views1 answer
Vba convert 2 bytes to an integer
VBA
0 vote193 views1 answer
Vbnet line graph smooth lines
VBA
1 vote209 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
1 vote152 views1 answer
How to open cmd with vbd
VBA
0 vote200 views1 answer
Vba get text file content
VBA