finding the data location of a list in my xls

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

Guest

Hi,

I have an xls with one of its column having a list for data validation. I
want to add additional values to the list. When I go to data validation, it
shows me as list and it shows me the name as TBL_PEOPLE. I thot it might be a
label, but could not find it anywhere in the xls. I know it is not accessing
any access tables. How can I find out where this TBL is so I can modify it?
Pls help.
 
Insert>Name>Define should show you a list of names in this workbook and the
refers to will show you the reference address.


Gord Dibben MS Excel MVP
 
Hi,

Hit the F5 key and enter the name you found (TBL_PEOPLE) and then click OK
it should show you the name range.

Thanks,
 

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

How to change the Tables! ? 3
Select from a list - 2003 Xls 3
Prevent List Box Reference from Changing when workbook closes? 3
showing cell locations per answer from Ron Coddere - stuck! 1
VBA - retrieve data on last create named range from previous inserted named range 0
xls 2007 ribbon 2
Importing Data from a pre-existing spreadsheet 2
Can't located named range 3

Back
Top