[RESOLVED] Excel: Determining Active Cell Position

[braabe01]

I am writing a VB Excel Macro and I am using the following code to determine the position of the active cell.

Dim InitialRow As Integer
    Dim InitialColumn As String 
 
    InitialRow = ActiveCell.Row
    InitialColumn = ActiveCell.Column

The problem is ActiveCell.Column returns an integer (i.e. it returns 3 instead of C). Does anyone know a way to return a C, or to convert the 3 to a C)?

If someone knows a function to return the full cell name (Column & Row instead of Column and Row individually), that would also work.

The reason that this is a problem is because I want to select this cell later using the function Range(<Cell>).Select, where Cell = String & Integer