I created an automation server with custom functions and I want to
allow the usage of named ranges. Normally when using functions and
named ranges the cell knows which item in the named range to use. In
my automation server the named range is passed as an object array. My
function does not know which cell is making the call so how do I know
from which cell to pull the text. Am I missing a property of the range
object that figures this out or do I need to find some way to pass in
the cell from the function is being called from?

When I have a range with a single cell, I just grab the text.