Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Pivot Tables in VBA

Pivot Tables in VBA

ResolvedVersion 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.

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Software Training London Ltd. t/a STL
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Registered in England and Wales.

Terms & Conditions Privacy & Cookie Policy