/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 vote362 views1 answer
Send text to clipboard vb.net
VBA
5 votes363 views1 answer
Xl vba double quotes in string literal
VBA
0 vote357 views1 answer
Switch pictures with buttons vb.net
VBA
-1 vote339 views1 answer
Text to speech vb.net
VBA
0 vote374 views2 answers
Excel vba number format file size
VBA
0 vote389 views1 answer
VBA
VBA
0 vote344 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
2 votes332 views1 answer
Date format for ms chart vb.net
VBA
0 vote358 views1 answer
Vba shape transparent
VBA
0 vote345 views1 answer
Vb run command
VBA