View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
moonhk[_2_] moonhk[_2_] is offline
external usenet poster
 
Posts: 36
Default Retrun row value for $A$12 , return 12

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