/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 vote217 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote246 views1 answer
Vba listbox remove all items
VBA
0 vote222 views1 answer
String contins in vba
VBA
0 vote217 views1 answer
Excel vba range contains
VBA
0 vote238 views1 answer
Visual basic run command
VBA
0 vote239 views1 answer
Vba sort the data Z to A
VBA
0 vote248 views1 answer
Vbscript remove spaces from string
VBA
5 votes238 views1 answer
Excel vba get user selected range
VBA
0 vote219 views1 answer
Change whcih control a user has selected vb
VBA
0 vote209 views1 answer
Excel vba milliseconds
VBA