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