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...o&userid=31075
View this thread: http://www.excelforum.com/showthread...hreadid=544157