guntikirankumar
New Member
Dear Friend,
Greeting to you,
my requirement is i am using excel 2003 at the begining i have a excel sheet with 200 rows of data based on 200 rows i made a pivot table but now my excel sheet is having 1000 rows when i am refreshing the pivot table it is taking 200 rows but not 1000 how to write a macro which automatically takes the number of rows in the sheet(weather it may be 100 rows or 50 rows or 1000 rows ) and do the refresh accordingly.
advance thanks
Greeting to you,
my requirement is i am using excel 2003 at the begining i have a excel sheet with 200 rows of data based on 200 rows i made a pivot table but now my excel sheet is having 1000 rows when i am refreshing the pivot table it is taking 200 rows but not 1000 how to write a macro which automatically takes the number of rows in the sheet(weather it may be 100 rows or 50 rows or 1000 rows ) and do the refresh accordingly.
advance thanks