Hi Tony

I don't if this can help
I am not sure, but if you want to change the string "R3C4" to the
string
"D3", then here is one way to do it.


Sub Example()
'// Convert string R3C4 to string D3
Dim Row, Col, NewAddress, sStr
sStr = "R3C4"
With Application
Row = Val(Mid(sStr, 2))
Col = Val(Mid(sStr, .Search("C", sStr) + 1))
End With
NewAddress = Cells(Row, Col).Address _
(RowAbsolute:=False, ColumnAbsolute:=False,
ReferenceStyle:=xlA1)
End Sub


--
jetted
------------------------------------------------------------------------
jetted's Profile: http://www.excelforum.com/member.php...o&userid=17532
View this thread: http://www.excelforum.com/showthread...hreadid=564339