Thread: Referencing cell in Named Range in Function VS Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nyq[_2_] Nyq[_2_] is offline
external usenet poster
  
Posts: 1
Default Referencing cell in Named Range in Function VS Formula

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

--
Ny
-----------------------------------------------------------------------
Nyq's Profile: http://www.excelforum.com/member.php...fo&userid=3538
View this thread: http://www.excelforum.com/showthread.php?threadid=55156

Reply With QuoteReply With Quote