Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract Column Letter from Cell Reference in another Cell
Hi
I have a cell with references another sheet in the same workbook and I would like to use place this column letter of the cell that is referenced in a separate cell Example: In Worksheet 1 Cell A2 formula = 'Worksheet2'!D18 b2 desired value D Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract Column Letter from Cell Reference in another Cell
Try this UDF:
Function letter(r As Range) As String Dim rr As Range S2 = Split(r.Formula, "!") Set rr = Range(S2(1)) S3 = Split(rr.Address, "$") letter = S3(1) End Function -- Gary's Student "JKBEXCEL" wrote: Hi I have a cell with references another sheet in the same workbook and I would like to use place this column letter of the cell that is referenced in a separate cell Example: In Worksheet 1 Cell A2 formula = 'Worksheet2'!D18 b2 desired value D Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract Column Letter from Cell Reference in another Cell
Try this UDF:
-- Gary's Student "JKBEXCEL" wrote: Hi I have a cell with references another sheet in the same workbook and I would like to use place this column letter of the cell that is referenced in a separate cell Example: In Worksheet 1 Cell A2 formula = 'Worksheet2'!D18 b2 desired value D Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
insert date | Excel Worksheet Functions | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |