/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

8 votes246 views1 answer
Excel vba make integer
VBA
2 votes238 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote231 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote225 views1 answer
Excel vba copy entire sheet paste values
VBA
0 vote229 views1 answer
Vbnet dynamically change excel sheet name
VBA
1 vote228 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote250 views1 answer
Vba cell all borders
VBA
0 vote252 views1 answer
Excel vba urlmon
VBA
0 vote249 views1 answer
.net crash app
VBA
0 vote273 views1 answer
Excel vba convert cells address
VBA