Prev: Is there a way to speed up Calculation !!!!!!!!!!!!!!!
Next: Checking if some cells are empty when file is being saved
From: zxcv on 29 Apr 2010 15:29
If a create a macro intended to be used as a function in a worksheet
is there a property of the referring cell?

I want to know what cell the formula is in.
From: JLGWhiz on 29 Apr 2010 15:50
Dim callCell As String
callCell = Application.Caller.Address

Returns the cell address of the cell where the UDF is used.


"zxcv" <zxcvnosend(a)yahoo.com> wrote in message
news:aef3cafd-4c52-40a6-8348-ebf957b3abad(a)a21g2000yqn.googlegroups.com...
> If a create a macro intended to be used as a function in a worksheet
> is there a property of the referring cell?
>
> I want to know what cell the formula is in.


From: zxcv on 29 Apr 2010 16:11
On Apr 29, 3:50 pm, "JLGWhiz" <JLGW...(a)cfl.rr.com> wrote:
> Dim callCell As String
> callCell = Application.Caller.Address
>
> Returns the cell address of the cell where the UDF is used.
>
> "zxcv" <zxcvnos...(a)yahoo.com> wrote in message
>
> news:aef3cafd-4c52-40a6-8348-ebf957b3abad(a)a21g2000yqn.googlegroups.com...
>
> > If a create a macro intended to be used as a function in a worksheet
> > is there a property of the referring cell?
>
> > I want to know what cell the formula is in.

Thanks.
 | 
Pages: 1
Prev: Is there a way to speed up Calculation !!!!!!!!!!!!!!!
Next: Checking if some cells are empty when file is being saved