Excel HowTo:
-Aviral Mittal
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAJgAAAAmCAIAAAC3YMVzAAACbElEQVR4nO2YS6KDIAxFu//VsAzWwAYyzYwhb6CQD1C11r6a5o4qVRJySIg+isuEHv/tgOs9cpBG5CCNyEEakYM0IgdpRA7SiBykETlII3KQRjQAGVxfKQdpRA7SiBykEX0CZIRcSsF07KmEpZQMcd/sTEcNTabbYfqbdCOQESANbukinvAchRWlg7xGEbLcC095JXw9MR3khVpyj7FJuBHphK+S/CGQS1hXLfHiJxWmdkuGJM4cdgK1P9jtjZW4FuYKphAiZFl0l9AjZiKQEFPnVr3GpHxm3BrI6uHAVEd6Ns6lnQlyqTS4N0onQVJ2rBOv067myRsQ4+v6RDPBPVOJQHPHGKWhECHrQNBsdYJqX7mlxjNEbZl7KB/mhz0/wmfjPUUyt9zC7hadxN4onQLZbbEWIx7JBNXWECRbh8yPHqS+EPkoTIoYUm3lkYuAfZD1DiBHBt7KddB+7sfHHKfx49PsjdIbQLI6QU6Tu8TxEpA4SPYZx8CKyKzz3QNyto4n65vtFWlbHid9MC4D2SLW775KEojjhSDnHEXxJb8yT0eqZR/IyNYzcAD/m5FkXXQOQ9/eBbLNulTGhGK52pXuTYXtMFq/Plu3QR49I0UsZLDqRts4I6/NyFaMMsD6k4ct4SBH622iuQOkf0B2dKyVE91uW7PqlTPEvkay8h76V0typRlnVaaU1gXLOZVjclvIcR304bOjVnZvlE6C/AbteOHXL5L98WhKNwW59UWgga4Fa9itWtJtQYbJK5v+sDvsMgzqziBDCPqzzw8Qm+gwSNcd5SCNyEEakYM0IgdpRA7SiBykETlII/oDSGAjwHIJXMMAAAAASUVORK5CYII=)
Here I present many interesting Functions, which are commonly
desired:
1. Convert Column Number to Column Character:
Function findColChar(colNum As Long) As String
findColChar = Split(Split(Columns(colNum).Address, "$")(1), ":")(0)
End Function
Now, Try this function:
Sub TrycolNumToColChar()
MsgBox findColChar(25)
End Sub
2. Convert Column Character to
Column Number:
Function findColNum(colChar As String) As Long
findColNum = Range(colChar & "1").Column
End Function
Now, Try this function:
Sub TrycolCharToColNum()
MsgBox findColNum("Y")
End Sub
<-Previous
Next ->