/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

2 votes159 views1 answer
Excel vba pause
VBA
0 vote210 views1 answer
Get month number from month name vbnet
VBA
0 vote201 views1 answer
Excel protect cells with formulas
VBA
0 vote195 views1 answer
Vb net check if file exists
VBA
3 votes211 views2 answers
Vba active workbook path
VBA
1 vote211 views1 answer
How to put a gridpain in a vbox
VBA
0 vote204 views1 answer
Reset border color textbox vba
VBA
0 vote170 views1 answer
Vba select file in folder
VBA
5 votes211 views1 answer
Excel vba second byte from INTEGER
VBA
0 vote200 views1 answer
Vbs expand env var
VBA