View Single Post
  #3 (permalink)  
Old August 4th, 2006, 07:28 AM
ladybird ladybird is offline
Registered User
Join Date: Aug 2006
Location: London, , United Kingdom.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to ladybird

Hi Tobi,

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

quote:Originally posted by oyelesit
 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
Reply With Quote