Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrun row value for $A$12 , return 12
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. -- Rick (MVP - Excel) "moonhk" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup will not retrun value | Excel Discussion (Misc queries) | |||
Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
Retrun "" (blank) | Excel Worksheet Functions | |||
Retrun a worksheet from a function | Excel Programming | |||
VBA Syntax for VLOOKUP to return array of return values | Excel Programming |