Need to know what cell called the custom VBA function?
 

I have developed a custom VBA function (foo). In a cell on the worksheet, I
add
=Foo() . When Foo begins to run, I want to know what is the activeCell.

Need to know what cell called the custom VBA function?
 

If you mean from which cell the function was called:

Dim r as Range
set r = Application.Caller

--
Gary''s Student


"partyOfOne" wrote:

I have developed a custom VBA function (foo). In a cell on the worksheet, I
add
=Foo() . When Foo begins to run, I want to know what is the activeCell.