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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Use worksheet name in one cell as part of reference in other cells 3
Using cell as worksheet reference (macro) 1
Formula to validate characters within a string of data in aparticular cell 1
Name a worksheet tab based on the value in a cell. 1
Ref Formula 4
When sharing, can I force an Excel document to open in a certain view? 0

Back
Top