| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Array question
UBound()
John www.ideo.com "Tom Walker" wrote in message ... hi, I have a function "HiddenItemslist" which returns an array of items. How do I know the no of items in the array after the function assignment? Like this: Dim A as variant A = ActiveSheet.PivotTables("PivotTable1").PivotFields ("[Project].[Project Name]"). _ HiddenItemsList "A" will have a list of items. Basically I want to traverse thru the list to see if an item that I want is there is not. how do I do this? Thanks, Tom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change array to simple columns | Excel Discussion (Misc queries) | |||
| IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
| Simple Array | Excel Discussion (Misc queries) | |||
| Make formula more simple --- array? | Excel Discussion (Misc queries) | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Threaded Mode
