| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named ranges
I have a name range of cells on a seperate worksheet in a workbook. I need
the range to dynamically change size so that only users can add values to the column or remove values from the column and the choicelist will still contain all values. The choice list dropdown is on sheet1 and the values are in a named range on sheet3. suggestions on how to do this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Named ranges
Also, the solution needs to work in office 2003 and 2007.
"hshayh0rn" wrote: I have a name range of cells on a seperate worksheet in a workbook. I need the range to dynamically change size so that only users can add values to the column or remove values from the column and the choicelist will still contain all values. The choice list dropdown is on sheet1 and the values are in a named range on sheet3. suggestions on how to do this? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Named ranges
Just make sure your dynamic range is a workbook range, not a worksheet range,
or you won't be able to use it with DataValidation. "hshayh0rn" wrote: I have a name range of cells on a seperate worksheet in a workbook. I need the range to dynamically change size so that only users can add values to the column or remove values from the column and the choicelist will still contain all values. The choice list dropdown is on sheet1 and the values are in a named range on sheet3. suggestions on how to do this? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Named ranges
Forgive my ignorance, how do I do that? I'm adding the formula to the "refers
to" field within the defines name box. "Barb Reinhardt" wrote: Just make sure your dynamic range is a workbook range, not a worksheet range, or you won't be able to use it with DataValidation. "hshayh0rn" wrote: I have a name range of cells on a seperate worksheet in a workbook. I need the range to dynamically change size so that only users can add values to the column or remove values from the column and the choicelist will still contain all values. The choice list dropdown is on sheet1 and the values are in a named range on sheet3. suggestions on how to do this? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Named ranges
http://peltiertech.com/Excel/Charts/...umnChart1.html
discusses how to create a dynamic chart. You use the same procedure for your dynamic range. HTH, Barb Reinhardt "hshayh0rn" wrote: I have a name range of cells on a seperate worksheet in a workbook. I need the range to dynamically change size so that only users can add values to the column or remove values from the column and the choicelist will still contain all values. The choice list dropdown is on sheet1 and the values are in a named range on sheet3. suggestions on how to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named ranges and pasting formulas with named references | Excel Programming | |||
| Named ranges scope / workbook/worksheet level named ranges- changeswith variable use... | Excel Programming | |||
| union of named ranges based only on the names of those ranges | Excel Programming | |||
| Copy data in named ranges to a newer version of the same template to identical ranges | Excel Programming | |||
| Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Hybrid Mode
