Referencing cell in Named Range in Function VS Formula

  • Thread starter Thread starter Nyq
  • Start date Start date
N

Nyq

New to VBA: when using a named range (say column A is 'ARange') in
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 pas
this either of these values to a Function?

TIA -

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

Regard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top