Home > other >  Use vba in the pivot table filter data have unlimited circulating decimal
Use vba in the pivot table filter data have unlimited circulating decimal

Time:09-28

I want to write a vba, filter out all in the pivot is greater than 6 number and check,
Because there are infinite decimals in the inside, so there is no way to get to the,

For iitem=1 To No19WS. PivotTables (" ピ ボ ッ ト テ ー ブ ル 2 "). The PivotFields (" actualhour "). PivotItems. Count

No19WS. PivotTables (" ピ ボ ッ ト テ ー ブ ル 2 "). The PivotFields (" actualhour "). PivotItems (iitem). The Visible=True
Next
For iitem=1 To No19WS. PivotTables (" ピ ボ ッ ト テ ー ブ ル 2 "). The PivotFields (" actualhour "). PivotItems. Count

No19String=No19WS. PivotTables (" ピ ボ ッ ト テ ー ブ ル 2 "). The PivotFields (" actualhour "). PivotItems (iitem)
If No19String & gt; 6 Then=
No19WS. PivotTables (" ピ ボ ッ ト テ ー ブ ル 2 "). The PivotFields (" actualhour "). PivotItems (iitem). The Visible=True
The Else

No19WS. PivotTables (" ピ ボ ッ ト テ ー ブ ル 2 "). The PivotFields (" actualhour "). PivotItems (iitem). The Visible=False
End the If
Next

Could you tell me how to change this code the,
  • Related