/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 vote227 views1 answer
Excel vba extract year
VBA
0 vote205 views1 answer
Remove frist letter from string vbnet
VBA
0 vote231 views1 answer
Excel vba Column Name to Column Number
VBA
0 vote232 views1 answer
Convert unix to date vba
VBA
0 vote238 views2 answers
Excel vba protect cells with formula
VBA
0 vote232 views1 answer
Vba type
VBA
2 votes166 views2 answers
Vba exit loop
VBA
3 votes219 views1 answer
Vba make long from two shorts
VBA
1 vote223 views1 answer
Excel vba get ordinal number from cardinal number
VBA
1 vote226 views1 answer
How to check is the value enterd is a number or text in vba
VBA