Displaying the Cell column/row number that you are in.

Actually, I figured out the answer. Found on a file that I had in a book...

Public Function XL_ColToLetter(ColumnNumber As Integer) As String 
    If ColumnNumber < 27 Then 
         ' Columns A-Z
        XL_ColToLetter = Chr(ColumnNumber + 64) 
    Else 
        XL_ColToLetter = Chr(Int((ColumnNumber - 1) / 26) + 64) & _ 
        Chr(((ColumnNumber - 1) Mod 26) + 65) 
    End If 
End Function

Thanks anyway.

Gary

Thank you for the solution.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE] before your code and [/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.