1. Sekolah Dasar
  2. Sekolah Menengah Pertama
  3. Sekolah Menengah Atas
  4. Mata Pelajaran
  5. Programming

Excel Vba Column Name From Column Number

[Solved] Excel Vba Column Name From Column Number | Vb - Code Explorer | yomemimo.com
Question : excel vba get column number from column name

Answered by : daniel-ferry

'For column IV...
ColNum = Columns("IV").Column

Source : | Last Update : Thu, 02 Apr 20

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 : excel vba Column Name from Column Number

Answered by : vastemonde

' Column name to column number
ColName = "A"
Debug.Print Range(ColName & 1).Column ' 1
' Column number to column name
ColNb = 1
Debug.Print Split(Cells(, ColNb).Address, "$")(1)

Source : https://stackoverflow.com/questions/10106465/excel-column-number-from-column-name | Last Update : Mon, 15 Feb 21

Answers related to excel vba column name from column number

Code Explorer Popular Question For Vb