Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function that Returns address of that cell?
Is there a function (or combination of) that will return the address (useable
in another function) of the cell that the function is in? For my particular project I cannot use any NAMES, or actual cell references (like putting "A1" in cell A1), or VB code. It requires a very specific solution, essentially a function (or combo of) that will return the address of the cell that the function is in. It seems SO simple and yet is nowhere to be found by me yet. HELP! THANKS! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function that Returns address of that cell?
Function Gary()
Debug.Print Application.Caller.Address MsgBox (Application.Caller.Address) End Function If the function has a range (single cell) as an argument like Function asdf(r as range) as variant Then r.Address will give the cell address -- Gary''s Student "RayWolfDog" wrote: Is there a function (or combination of) that will return the address (useable in another function) of the cell that the function is in? For my particular project I cannot use any NAMES, or actual cell references (like putting "A1" in cell A1), or VB code. It requires a very specific solution, essentially a function (or combo of) that will return the address of the cell that the function is in. It seems SO simple and yet is nowhere to be found by me yet. HELP! THANKS! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function that Returns address of that cell?
In the worksheet:
=ADDRESS(ROW(),COLUMN()) will also display the address -- Gary''s Student "RayWolfDog" wrote: Is there a function (or combination of) that will return the address (useable in another function) of the cell that the function is in? For my particular project I cannot use any NAMES, or actual cell references (like putting "A1" in cell A1), or VB code. It requires a very specific solution, essentially a function (or combo of) that will return the address of the cell that the function is in. It seems SO simple and yet is nowhere to be found by me yet. HELP! THANKS! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell address | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
If function that returns value in a cell. | Excel Worksheet Functions | |||
How do I obtain the address of a cell using the vlookup function? | Excel Worksheet Functions | |||
How do I use a function to return the address of a cell? | Excel Worksheet Functions |