View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] ivan.panov@gmail.com is offline
external usenet poster
 
Posts: 1
Default All Worksheets in a Data Validation combo

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.