Question : excel vba get column name from number
Answered by : daniel-ferry
'For column number 256...
ColName = Split(Cells(, 256).Address, "$")(1)Source : | Last Update : Thu, 02 Apr 20
Question : get all column names from excel vba
Answered by : misty-markhor-uqv6dhh5ermr
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 SubSource : https://www.mrexcel.com/board/threads/vba-collecting-all-the-heading-names-into-an-array.990945/ | Last Update : Sun, 17 Jan 21