View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default Set Pivot-Table Visible Items

With ActiveSheet.PivotTables("AssetPT").PivotFields("Co st ctr")
.PivotItems("12476").Visible = True
.PivotItems(DataArray(X, 1)).Visible = True
end with

Why would the line with "12476" work and the line immediately below, where
DataARray(x,1) equals "12476" give me this error:

Error (1004) Unable to get teh pivotItems property of the pivotfield
class?????