Question : excel get column number
Answered by : riccardo-biffi
=COLUMN(A1)
The COLUMN function returns the column number of the given cell reference.
=COLUMN(D10) returns 4 because column D is the fourth column.
Source : https://support.microsoft.com/en-us/office/column-function-44e8c754-711c-4df3-9da4-47a55042554b#:~:text=The%20COLUMN%20function%20returns%20the,D%20is%20the%20fourth%20column. | Last Update : Fri, 08 Jul 22
Question : how to find column number in excel
Answered by : beatrix-garai
Sub acitveCellInfo() MsgBox "Active-column: " & ActiveCell.Column & ", Active-Row: " & ActiveCell.Row, vbInformation, "Active Cell"
End Sub
'if you want to see the column Nr's during working in Excel table you can change the reference-style
Sub changeReferenceStyle() Application.ReferenceStyle = xlA1 + xlR1C1 - Application.ReferenceStyle
End Sub
Source : | Last Update : Wed, 22 Jun 22