Pivot Tables in VBA

Resolved · Low Priority · Version 2003

Fri 13 May 2011, 11:51 Delegate Jim said...

Jim has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA Advanced course

Pivot Tables in VBA

Hi

What is the code to exclude an item in a drop down box of a row in a Pivot Table in VBA

The options for countries are:

'show all',
'England',
'Wales', &
'Scotland'

I want to uncheck the 'Scotland' box so only England and Wales appear in my Pivot Table

Fri 13 May 2011, 12:05 Delegate Jim said...

RE: Pivot Tables in VBA

Don't worry, I have resolved it now.

Excel tip:

Sorting data stored in rows

Primarily Excel is set up to sort data that is stored in columns rather than rows.

It is possible to get Excel to sort data stored in rows however.

Click in the row you want to sort, or select the cells in the rows you wish to sort.

Go to Data - Sort, then go to the Options button in the bottom left corner of the Sort dialogue box.

View all Excel hints and tips

Pivot Tables in VBA

Pivot Tables in VBA

RE: Pivot Tables in VBA

Excel articles

Excel tip:

Sorting data stored in rows