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