/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 vote272 views2 answers
Delete all controls from list of control vb.net
VBA
2 votes243 views1 answer
Excel vba check if string entirely numeric
VBA
1 vote250 views1 answer
Vbs run
VBA
0 vote271 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
2 votes232 views1 answer
Date format for ms chart vb.net
VBA
1 vote276 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
5 votes262 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote224 views2 answers
Excel vba copy paste after last row
VBA
0 vote237 views1 answer
Excel vba cell on change
VBA
0 vote239 views1 answer
Windows Presentation Foundation dark title bar
VBA