getting range from address 2

[venkman]

If I have a string variable that has an absolute address stored in it in r1c1 format (for insance "R13C2&quot, how do I get a range from that? I thought Range(sAddress) would work (where sAddress is the string in question), but it didn't.

I'm looking for a very simple solution. In the meantime I'm parsing the string using Instr() and Mid() to find out which number is the column and which number is the row.

Thanks,
Venkman

 

[sfvb]

Here's a couple of examples:

r1c1Address = "R13C2"
Range(Application.ConvertFormula(r1c1Address, xlR1C1, xlA1)).Select

r1c1Address = "R13C2:R13C7"
Range(Application.ConvertFormula(r1c1Address, xlR1C1, xlA1)).Select[/color]

 

[venkman]

Thanks, that worked.