How to convert from x y Excel coordinates R1C1 to A1 notation range?

[Gianni]

Hi
Does someone know if there is an easy way to convert numerical coordinates of row, column to an A1 notation range object (or at least to an A1 notation string)?
that is: if I have 2 numerical values for row and column, say row 3 and column 5, I would get an E3 string or better an $oRange object rappresenting that range (a single cell in this case)
Thanks on advance.

Edited November 26, 2015 by Chimp

[Danyfirex]

Cells(Row,Column).Address 

EDIT

Excel udf has one to do it.

_Excel_ColumnToLetter

Saludos

Edited November 24, 2015 by Danyfirex
Edit

[Danyfirex]

I wrote this:

Func _GetNotation($oExcel,$iX,$iY)
    if IsObj($oExcel) Then
        Return StringReplace($oExcel.Cells($iX,$iY).Address,"$","")
    EndIf
EndFunc

Saludos

[Gianni]

Thanks a lot Danyfirex,
exactly what I was loocking for.

Saludos 

[water]

Or use functions _Excel_ColumnToLetter and _Excel_ColumnToNumber.

[Gianni]

 Thanks a lot water for pointing writing also those useful functions

cheers

Edited November 25, 2015 by Chimp

[water]

As I have dropped support for R1C1 notation in the new Excel UDF I had to provide such functions

[Gianni]

As I have dropped support for R1C1 notation in the new Excel UDF I had to provide such functions

Well done water!

... Also, about this subject, I would advise those who have to deal with excel's ranges, this nice tutorial, also by @water

https://www.autoitscript.com/wiki/Excel_Range

[Bioform]

=cell("address", indirect(address(R,C)))

R is your row number, C = column number

=cell("address", indirect(address(6,2))) would return $B$6