ExcelBanter - 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