I already have a pivot table created using pivot table wizard. The layout for the pivot table is expected to remain unchanged. However, I am trying to write code that adjusts the reference source range to reflect the number of rows in the source range (located in a different worksheet). In other words, the only thing that is expected to change regarding pivot table and/or source data is number of rows. Can you assist? Thanks.

(By the way, I have seen several codes using the PivotCaches.Add method. However, I think it's an overkill for my purpose)

T Oyelesi

may I suggest you look at the following posting...

http://p2p.wrox.com/topic.asp?TOPIC_ID=34586

It follows a very similar line to your requirement.

Cheers

Matt

[email protected]

Hi Tobi,

This is way off the subject but do you know a Janet Adeyemi??
:)