Posted to microsoft.public.excel.misc

M&M[_2_]

external usenet poster

Posts: 33

NUmber of Columns

Hi, I have a named range in which I have some values. However this range will
be changing all the time. Maybe will increase in number of colums and rows
maybe decrease depending on the inputs of the user.

How can I make it so that the range remains named "Data" and changes in size
when the user inputs values?

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
number of columns	ekkeindoha	Excel Discussion (Misc queries)	4	July 8th 07 03:31 PM
Number of columns	Duplex	Excel Discussion (Misc queries)	3	October 20th 06 02:02 PM
Max number of columns?	Al	Excel Discussion (Misc queries)	1	March 17th 06 11:46 AM
Number of Columns	Pedro Mestre	Excel Discussion (Misc queries)	2	October 20th 05 11:24 AM
Number of columns ?	Toosje	Excel Worksheet Functions	2	March 16th 05 11:41 AM

All times are GMT +1. The time now is 02:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us