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
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