Posted to microsoft.public.excel.programming

DynamiteSkippy DynamiteSkippy is offline

external usenet poster

Posts: 19

Modify Pivot Table Page Field

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot Table Page Field	Nate	Excel Discussion (Misc queries)	4	December 24th 07 03:11 PM
Page field - pivot table	yshridhar	Excel Discussion (Misc queries)	0	August 1st 07 04:48 AM
Pivot Table Page Field	Neily	Excel Discussion (Misc queries)	3	February 24th 05 01:23 PM
Pivot Table Page Field	Jimbola	Excel Discussion (Misc queries)	0	February 6th 05 09:13 PM
Pivot Table Page Field	Todd Huttenstine	Excel Programming	2	May 6th 04 04:24 PM

All times are GMT +1. The time now is 06:49 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us