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.

Here is an example:

If my named range is 10 cells in a column (example: MyRange = a1:a10)
if I am calling the function from b3 passing in MyRange I will get the
a3 value.

Leo,
In VB, it would be something like:
Public Function RangeValue(argNamedRange As Range) As Variant
RangeValue = argNamedRange.Range("A1").Offset(Application.Calle r.Row - 1, 0)
End Function

NickHK

"LJ" wrote in message
oups.com...
Here is an example:

If my named range is 10 cells in a column (example: MyRange = a1:a10)
if I am calling the function from b3 passing in MyRange I will get the
a3 value.