Hi All,
Is there a method or property similar to "CurrentPage" (please see the following code sentence where "Estado_comisión" is set as page filter), which I can apply to select only one item of a pivotfield, instead of my actual procedure of switching visible property TRUE for all pivotitems in a row pivot field and then swithching FALSE all undesired values within a for...next loop?.
ThisWorkbook.Worksheets("Hoja1").PivotTables("Tabla dinámica1"). _
PivotFields("Estado_comisión").CurrentPage = "Pagada"
Thank you
selopezr
Bookmarks