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.
 
Back
Top