Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Greetings:
How to show a cell reference as Text: Example: Cell C3: Has input of =+G12, Shows value of 236 Cell D3: Need to "extract" the cell reference used in C3. To show as text. Should read G12 As per instructions found in ng (if I'm reading it correctly): In cell D3, I entered =ws(C3) I then copy and paste the code in a new module, in the workbook. Function ws(rg As Range) As String If InStr(1, rg.Formula, "!") 0 Then ws = Mid(rg.Formula, 2, InStr(1, rg.Formula, "!") - 2) End If End Function Back to my spread-sheet, Cell D3 reads =ws(C3). It does NOT read G12, as I expected. I have a feeling I'm overlooking something VERY obvious here, but I can't seem to get a handle on it. Help, please. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Show cell reference as text | Excel Discussion (Misc queries) | |||
Show Cell Reference | Excel Worksheet Functions | |||
Show values in formula instead of cell reference | Excel Worksheet Functions | |||
Formula to show zero if reference cell is zero? tricky! | Excel Worksheet Functions | |||
help to show formart in reference cell | Excel Worksheet Functions |