can u have a name that is a ref to cells in a worksheet in an add-
 

I would like to have a cell that I have added Validation to and would like to
specify list and then use a =name as the source. I would then like the name
to be a reference to some cells on a worksheet in an add-in, is this possible?

I have created the name in the xla, but I can not simply use =name as the
source in my other workbook, it complains about not be able to find the name.

--
Trefor

can u have a name that is a ref to cells in a worksheet in an add-
 

Debra Dalgleish explains it all:
http://contextures.com/xlDataVal05.html

Trefor wrote:

I would like to have a cell that I have added Validation to and would like to
specify list and then use a =name as the source. I would then like the name
to be a reference to some cells on a worksheet in an add-in, is this possible?

I have created the name in the xla, but I can not simply use =name as the
source in my other workbook, it complains about not be able to find the name.

--
Trefor

--

Dave Peterson

can u have a name that is a ref to cells in a worksheet in an
 

Thanks Dave.
--
Trefor


"Dave Peterson" wrote:

Debra Dalgleish explains it all:
http://contextures.com/xlDataVal05.html

Trefor wrote:

I would like to have a cell that I have added Validation to and would like to
specify list and then use a =name as the source. I would then like the name
to be a reference to some cells on a worksheet in an add-in, is this possible?

I have created the name in the xla, but I can not simply use =name as the
source in my other workbook, it complains about not be able to find the name.

--
Trefor

--

Dave Peterson