View Single Post
Old September 8th, 2005, 03:15 PM
oyelesit oyelesit is offline
Registered User
Join Date: Sep 2005
Location: Summit, New Jerse, USA.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Pivot Table Dynamic Reference Data

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