get_PageFields

[Tysken]

Hello,

I have a small problem in my Excel Addin that i'm working with.

I'm trying to get the items that are chosen in my filter but do not get it
to work.

How do I iteralte over the filter values that are chosen?

My dimension looks like this

Year
All
|- 2008
|- 2009

I've tried get_PageFields, but dont get it to work. I can only get 'All' but
not 2008 that are the value that are choosen.

 

[Per Jessen]

Hi

Suppose you have filtered range A1:A100 with headings in A1, try this:

Dim FilteredRange as Range
Set FilteredRange="A2:A100" '(Exclude header row)
For Each cell in FilteredRange.SpecialCells(xlCellTypeVisible)
.....
Next

Hopes this helps.
....
Per