Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
All Worksheets in a Data Validation combo
-- 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidate Several Workbooks into One | Excel Worksheet Functions | |||
List, Combo Box, Data Validation?? | Excel Discussion (Misc queries) | |||
Data Validation or Conditional Format (or combo of) | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) |