I need to get the integer value from the address R[4]C, any ideas ?

I'm not quite sure how you got this string, but this worked ok for me:

Option Explicit
Sub testme()
Dim myStr As String
Dim OpenBrktPos As Long
Dim CloseBrktPos As Long
myStr = "R[433]C"

OpenBrktPos = InStr(1, myStr, "[", vbTextCompare)
CloseBrktPos = InStr(1, myStr, "]", vbTextCompare)

Debug.Print Mid(Left(myStr, CloseBrktPos - 1), OpenBrktPos + 1)

End Sub


But =r[4]c means that it's 4 rows down from the cell containing that formula (in
the same column).

Goofy wrote:

I need to get the integer value from the address R[4]C, any ideas ?

--

Dave Peterson

myStr = "R[433]C"
was really
myStr = "R[4]C"
On my first test.


Dave Peterson wrote:

I'm not quite sure how you got this string, but this worked ok for me:

Option Explicit
Sub testme()
Dim myStr As String
Dim OpenBrktPos As Long
Dim CloseBrktPos As Long
myStr = "R[433]C"

OpenBrktPos = InStr(1, myStr, "[", vbTextCompare)
CloseBrktPos = InStr(1, myStr, "]", vbTextCompare)

Debug.Print Mid(Left(myStr, CloseBrktPos - 1), OpenBrktPos + 1)

End Sub

But =r[4]c means that it's 4 rows down from the cell containing that formula (in
the same column).

Goofy wrote:

I need to get the integer value from the address R[4]C, any ideas ?

--

Dave Peterson

--

Dave Peterson