Suppose I have a named range G3:H5 that I use for some Vlookup or other
applicaitons.

Now I have additional data to add to this named range in cells G6 and H6.
How can I reconfigure the named range so it now includes G3:H6?

You can delete the name and higlight the new range and name it with the
same name you deleted. Don't forget to note the name before you delete
it otherwise your dependent formulas won't work.


--
renegan
------------------------------------------------------------------------
renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450
View this thread: http://www.excelforum.com/showthread...hreadid=535108

Insert|Name|define. Click on the cells icon on the right of the address
field, and block G3:H6

"Dan" wrote:

Suppose I have a named range G3:H5 that I use for some Vlookup or other
applicaitons.

Now I have additional data to add to this named range in cells G6 and H6.
How can I reconfigure the named range so it now includes G3:H6?

Uh-huh. That works. Thanks!

"kassie" wrote:

Insert|Name|define. Click on the cells icon on the right of the address
field, and block G3:H6

"Dan" wrote:

Suppose I have a named range G3:H5 that I use for some Vlookup or other
applicaitons.

Now I have additional data to add to this named range in cells G6 and H6.
How can I reconfigure the named range so it now includes G3:H6?