Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation with offset range and other?
Hi,
I've used the offset function in the past to create a dynamic range that can then be used for data validation. I'm wondering if I can create a range using offset, and add to it another arbitrary list value. i.e., a sample dynamic list might be: red yellow blue but I want to create a list like: all red yellow blue Where the value 'all' doesn't exist in the range created by the offset function. Thanks in advance for any help. David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation with offset range and other?
Hi David;
If you're wanting to do it in memory you can use an array or if you want to use the cells in the user interface you can use the cells method. Look under range in help and then for the cells method. Thanks, Greg -----Original Message----- Hi, I've used the offset function in the past to create a dynamic range that can then be used for data validation. I'm wondering if I can create a range using offset, and add to it another arbitrary list value. i.e., a sample dynamic list might be: red yellow blue but I want to create a list like: all red yellow blue Where the value 'all' doesn't exist in the range created by the offset function. Thanks in advance for any help. David . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
OFFSET Range | Excel Worksheet Functions | |||
MATCH OFFSET LIST VALIDATION | Excel Discussion (Misc queries) | |||
Dynamic Range, Data Validation and Address, Match and Offset Funct | Excel Worksheet Functions | |||
range offset | Excel Programming |