Retrun row value for $A$12 , return 12

  • Thread starter Thread starter moonhk
  • Start date Start date
M

moonhk

Hi All

How to return $A$12 , 12 by Excel rows/address function ?

Current I am using below coding.

Function get_row(loString)
Dim a As String

get_row = Mid(loString, InStr(2, loString, "$") + 1, Len(loString) -
InStr(2, loString, "$"))


End Function

Sub test()
Dim a As String
a = "$A$12"
MsgBox get_row(a)
End Sub
 
I would probably use this method myself...

Function get_row(loString)
get_row = Range(loString).Row
End Function

That way, the address being passed into the function can have any
combination of absolute and/or relative address components.
 
Back
Top