| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Get cell address from macro function argument
Is it possible to know the address of the cell that is passed as argument to
a macro function? I want to know this to compare to the cell next to the one passed to the function. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Get cell address from macro function argument
Yes:
Function qwerty(r As Range) As Integer MsgBox (r.Offset(0, 1).Address) qwerty = 0 End Function -- Gary's Student "oscar" wrote: Is it possible to know the address of the cell that is passed as argument to a macro function? I want to know this to compare to the cell next to the one passed to the function. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Get cell address from macro function argument
Thank you for your reply.
Is it possible to use that macro in the formula bar? I tryed with =qwerty(A1) and I got #NAME? Thank you for your time "Gary''s Student" wrote: Yes: Function qwerty(r As Range) As Integer MsgBox (r.Offset(0, 1).Address) qwerty = 0 End Function -- Gary's Student "oscar" wrote: Is it possible to know the address of the cell that is passed as argument to a macro function? I want to know this to compare to the cell next to the one passed to the function. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Get cell address from macro function argument
Yes you can.
First you need to copy the 4 line function and paste it in VBA editor. See: http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Gary's Student "oscar" wrote: Thank you for your reply. Is it possible to use that macro in the formula bar? I tryed with =qwerty(A1) and I got #NAME? Thank you for your time "Gary''s Student" wrote: Yes: Function qwerty(r As Range) As Integer MsgBox (r.Offset(0, 1).Address) qwerty = 0 End Function -- Gary's Student "oscar" wrote: Is it possible to know the address of the cell that is passed as argument to a macro function? I want to know this to compare to the cell next to the one passed to the function. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Row Expansion | Excel Worksheet Functions | |||
| Function that Returns address of that cell? | Excel Worksheet Functions | |||
| ADDRESS function - dynamic input cell | Excel Discussion (Misc queries) | |||
| Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Linear Mode
