Finding the location of a function programatically

[LoopCost]

How do I find the current location of a function? I am creating a new function to be used in excel like Sumif, Count, etc.

I want to evaluate a named range but I dont want to evaluate previous rows. Say I had a named 1 x 10 range (myRange) to search. In the next column I use myFunction to evaluate the named range. On the first instance I want to evaluate all 10 rows. On the next occurence of myFunction I want to evaluate 9 rows and so on. I could do this if I knew from what cell my function was running
from. I need to do this without adjusting the named range. Any ideas??

Thanks

 

[Juan Pablo González]

Nope, I don't understand... I think you need an array formula, for the UDF to "know" what has happened to its "surroundings", but, not sure what you want.

 

[Swamp Thing]

Check out Application.Caller. This will return a range object if the function has been called from a cell. The range obj. will then refer to the cell containing the function call.

E.g. Application.Caller.Address will return the address of the cell from which the function is called.

 

[LoopCost]

Thanks the application.caller did the trick.