I have a few user defined formulas that are in a spreadsheet. When I open
Excel with automatic calculation turned on, it goes through each cell and
executes my formulas as expected.

What I need to know is which cell is being calculated? If I have 5 cells
with one of my formulas, I would expect my formula to be called 5 times
(which it is), but I want to know which cell is being calculated each time.

Application.ActiveCell only tells you the cell where the cursor is. It does
not change as Excel iterates through each cell to calculate them.

I believe you could put something like

Debug.print Application.Caller.Address

in your UDF and then look at the immediate window.
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"J. Caplan" wrote:

I have a few user defined formulas that are in a spreadsheet. When I open
Excel with automatic calculation turned on, it goes through each cell and
executes my formulas as expected.

What I need to know is which cell is being calculated? If I have 5 cells
with one of my formulas, I would expect my formula to be called 5 times
(which it is), but I want to know which cell is being calculated each time.

Application.ActiveCell only tells you the cell where the cursor is. It does
not change as Excel iterates through each cell to calculate them.

That's it!! I knew it would be something simple, but I didn't even notice
the Caller property. Thanks!!

"Barb Reinhardt" wrote:

I believe you could put something like

Debug.print Application.Caller.Address

in your UDF and then look at the immediate window.
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"J. Caplan" wrote:

I have a few user defined formulas that are in a spreadsheet. When I open
Excel with automatic calculation turned on, it goes through each cell and
executes my formulas as expected.

What I need to know is which cell is being calculated? If I have 5 cells
with one of my formulas, I would expect my formula to be called 5 times
(which it is), but I want to know which cell is being calculated each time.

Application.ActiveCell only tells you the cell where the cursor is. It does
not change as Excel iterates through each cell to calculate them.