Hi everyone,
In the formula of a cell, I call a user-defined function in which the arguments it receives are passed as ByRef.
The function is defined thus:
Function Next_Due_Date(ByRef start_date As Date, ByRef frequency_label As String)
...
End Function
Let's say cell C1 contains:
=Next_Due_Date(A1, B1)
in which A1 contains a date and B1 a text-string.
Inside the function Next_Due_Date, I want to find out what the cell addresses were (A1 and B1) from which start_date and frequency_label came, in addition to the values they hold.
Can this be done, please? I tried:
a = start_date.Address
but that produced an "invalid qualifier" compiler error.
Thanks in anticipation.