Posted to microsoft.public.excel.programming

Grant[_5_] Grant[_5_] is offline

external usenet poster

Posts: 4

Setting pivot table field (current page) to a chosen value

Hello,

I have the following code:

ActiveSheet.PivotTables("PvtVarianceRpt2").PivotFi elds
("Line").CurrentPage = cboLine.Name

Where cboLine is a combo drop down list.

It keeps asking for "Object required"

How might I go around fixing this?

Thanks in advance for the replies,
Grant.

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
Changing a field setting in a pivot table	The Rook[_2_]	Excel Discussion (Misc queries)	3	September 5th 08 05:29 PM
Setting default pivot table field setting to "sum"	Mr. Moose	Excel Discussion (Misc queries)	2	December 21st 04 04:43 PM
Pivot Table Page Field	Todd Huttenstine	Excel Programming	2	May 6th 04 04:24 PM
Setting Pivot Table Page Field Names using VBA	Ron McCormick[_2_]	Excel Programming	1	November 7th 03 12:45 PM
Setting Pivot Table Page Field Names using VBA	Ron McCormick[_2_]	Excel Programming	0	November 7th 03 10:35 AM

All times are GMT +1. The time now is 02:35 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us