PivotTable using Named Ranges
 

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

PivotTable using Named Ranges
 

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.

--
Regards,
Tom Ogilvy

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

PivotTable using Named Ranges
 

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 he

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.


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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html