Hello again,

Each answer just clears me long enough to find the next
question. But I'm almost home.

I have a macro which creates 3 pivot tables on a single
tab. Essentially the first one shows "active" stuff, the
2nd shows "potential" and the third shows "completed"
items. (that's the way management wants to see them).

The trick is that right now, I have it hard-coded to
create one at row 15, the 2nd at row 100 and the third at
row 200, because I can't predict how big they'll be.

Is there a way to ask Excel to go to the end of a pivot
table, move down 2 rows, and then start the next one??
Or just get a count of the pivot size, so i can
programmatically do the same thing.

As always, any help is sincerely appreciated.

Thanks,
Randy