All Worksheets in a Data Validation combo

  • Thread starter Thread starter ivan.panov
  • Start date Start date
I

ivan.panov

I used Get.Workbook(1) and derived an array of all worksheets' names
(eg. wsNames). When I try to put it as a list in Data Validation
(=wsNames) I get an error.

Also: Cant get complete reference about these Get.xxx(x) anywhere.
Where did they come from?
I haven't read about them in any book available.
 
(e-mail address removed) --> that's me :))

I found XLMacro.chm . Don't need any other reference.
The question remains where can I use this functions.
What are the limitations and how to go around them.
 
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

Saving a worksheet to a new workbook 6
Rename a worksheet to use with a pivot table 1
Open Workbooks, Used Area on Sheet 3
Delete All Links to Worksheet 1
if condition with data validation list 5
Copy and paste last row 6
Data Validation - Complex Q 2
Data Validation - Excel 2007 5

Back
Top