PivotTable using Named Ranges

[John]

I am creating a pivottable in excel 2003 using VBA and
wanted it to reference two named ranges. How do you do
that?

 

[Tom Ogilvy]

Turn on the macro recorder and create the pivot table manually, having it
refer to the two named ranges.

When done, turn off the macro recorder.

Look at the recorded code. Make adjustments as appropriate.

 

[Debra Dalgleish]

In addition to Tom's excellent advice, note that you can create a Pivot
Table from multiple consolidation ranges, but you won't get the same
pivot table layout that you'd get from a single range. There's an
example here:

http://www.contextures.com/xlPivot08.html

If possible, store your data in a single range, and you'll have more
flexibility in creating the pivot table.