| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capture cell address in UDF
Hi NG!
Is there a way of capturing the cell address of an argument in a UDF in stead of the value of the argument. I have a UDF definition like Function Test(arg) .... End Function when I use the function I type =test(A1) and i get the value of A1. But what I like to captuire is the address A1 Is there any way to achieve this? Jan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Capture range object address | Excel Programming | |||
| Use VBA to capture IP address | Excel Programming | |||
| Capture Dynamic Range address into Modeless Form | Excel Programming | |||
| Capture Dynamic Range address into Modeless Form | Excel Programming | |||
| Capture Outlook E-Mail Address | Excel Programming | |||
Threaded Mode
