Thread: Modify Pivot Table Page Field
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default Modify Pivot Table Page Field
Fully qualify the reference to range("H26"), or Excel will assume that
it's on Sheet2:

ActiveSheet.PivotTables("PivotTable2") _
.PivotFields("Product Line").CurrentPage _
= Sheets("Sheet1").Range("H26").Value


DynamiteSkippy wrote:
I am trying to use a cells contents--in H26 on Sheet1- and trying to modify a
pivot table page field--on Sheet2.

The code is below.

ActiveSheet.PivotTables("PivotTable2").PivotFields ("Product
Line").CurrentPage _
= Range("h26").Value

It may be using the .visible property but I can't seem to use that
correctly.Does anyone have any ideas?

Thanks


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply With QuoteReply With Quote