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 » Creating Pivot Tables

Creating Pivot Tables

ResolvedVersion 2003

Mon 8 Sep 2008, 16:36 Delegate Angela said...

Angela has attended:
Excel VBA Intro Intermediate course

Creating Pivot Tables

what does PivotSelection do?

Thu 11 Sep 2008, 09:58 Trainer Carlos said...

RE: Creating Pivot Tables

Hi Angela

The PivotSelection property returns a PivotTable selection in the standard PivotTable report format.

The syntax is as follows:

expression.PivotSelection

An example of this would be as below:

This selects the data and label for the salesperson named Karen Draper in the PivotTable report on the worksheet.

Worksheets(

Excel tip:

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Creating Pivot Tables

Creating Pivot Tables

RE: Creating Pivot Tables

Excel articles

Excel tip:

DATEDIF function