Thread: Referencing cell in Named Range in Function VS Formula

New to VBA: when using a named range (say column A is 'ARange') in a worksheet cell formula, the current row value is referenced by default. How do I reference a different row in this range, and how do I pass this either of these values to a Function?

TIA -

=Index(ARange,3,1)

will be A3

--
Regards,
Tom Ogilvy


"Nyq" wrote:

>
> New to VBA: when using a named range (say column A is 'ARange') in a
> worksheet cell formula, the current row value is referenced by default.
> How do I reference a different row in this range, and how do I pass
> this either of these values to a Function?
>
> TIA -
>
>
>
>
> --
> Nyq
> ------------------------------------------------------------------------
> Nyq's Profile: http://www.excelforum.com/member.php...o&userid=35380
> View this thread: http://www.excelforum.com/showthread...hreadid=551566
>
>

Thanks! So simple: thus one wd invoke Function 'Fnc1' as:
=Fnc1(INDEX(ARange,3,1)).

Regards