[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

[Static]

MsgBox ActiveCell.Address

[Hack]

Excel VBA question moved to Office Development

[Ecniv]

Just for future info - I think there is a function in Excel that converts r1c1 address to the 'normal' address... Cannot remember what it was though, should be in the helpfiles or under intellisense of

Although R1c1 makes more sense...