RE: Changing named ranges

Giganews Newsgroups
Subject: RE: Changing named ranges
Posted by:  MarkN
Date: Sun, 21 May 2006

Take a look athttp://www.contextures.com/xlNames01.html about dynamically
named ranges.

--
hope this helps,
MarkN

"Gazzr" wrote:

>
> Hi there,
>
> Consider an example where I have Defined a named range called "garry"
> which covers cells A1:E5. How can I get excel to update/change the
> named range to A1:E10 if I paste five more rows of data into the
> sheet.
>
> I want to do this without going into Insert > Name > Define etc and
> changing it manually.
>
> Hope all that made sense.
>
> Thanks
> Gazzr
>
> --
> Gazzr
> ------------------------------------------------------------------------
> Gazzr's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=31075
> View this thread:http://www.excelforum.com/showthread.php?threadid=544157

Replies

In response to

Changing named ranges posted by Gazzr on Mon, 22 May 2006