Thanks what you have provided works but now I realized why I was having problems - the name of the named range is not RngName but rather the value of the contents of RngName (RngName is a single cell).

How does that change things?

Sorry for the confusion with this.

David


On Monday, November 23, 2015 at 12:32:35 PM UTC-7, Claus Busch wrote:
Hi Garry,

Am Mon, 23 Nov 2015 14:28:02 -0500 schrieb GS:

I have tried something like this =OFFSET(index(RngName,1,1),-13,3)

that is the better solution. I did not realize that the named range can
have more than one column.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional