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
Bookmarks