Changing named ranges

Giganews Newsgroups
Subject: Changing named ranges
Posted by:  Gazzr (Gazzr.2870yy_1148274901.0924@excelforum-nospam.com)
Date: Mon, 22 May 2006

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