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

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
.