Posted to microsoft.public.excel.misc

N.F[_2_]

external usenet poster

Posts: 65

Range Question

If I have a named range for instance $A$11 : $C$14 = Range("TEST")

and I want to add any more values to this range how can i make it so that the
user can add more values which are outside this range and have the range
automatically change to capture the newer values as well in the same named
range("TEST")

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Countif range question	Judoguy	Excel Discussion (Misc queries)	1	April 5th 07 09:38 AM
Named range question	Shane Henderson	Excel Discussion (Misc queries)	2	April 7th 06 03:38 AM
Range question in '97	Adam Kroger	Excel Discussion (Misc queries)	10	December 12th 05 03:44 AM
Question for use of offset and range	Demi	Excel Worksheet Functions	3	July 22nd 05 08:48 PM
Question on LABEL Range	Sarah Tanembaum	Excel Discussion (Misc queries)	2	December 15th 04 11:49 PM

All times are GMT +1. The time now is 09:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us