/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 vote342 views2 answers
S yyyy-MM-dd em vb net
VBA
0 vote304 views1 answer
Vbnet display all axis labels in cahrt
VBA
1 vote304 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote320 views1 answer
VBA Sort RossetaCode
VBA
0 vote337 views1 answer
Vbnet check if string is only letters
VBA
1 vote323 views1 answer
Excel vba saveas force overwrite
VBA
0 vote310 views1 answer
Vbs
VBA
1 vote326 views1 answer
What does vbs stand for
VBA
-1 vote339 views1 answer
How save excel through visual basic
VBA
8 votes464 views1 answer
Vba convert 2 bytes to an integer
VBA