View Single Post
  #1   Report Post  
Trefor
 
Posts: n/a
Default 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