range pivottable

[matrixknow]

my pivottable has a certain fixed range to his datasource

Please Login or Register  to view this content.

to this data source periodically new rows are added. With a fixed range he can't retrieve the new information.

1. In the datasource I should find the last row number. ok
2. This number should become part of the range. How to write the range of the pivot to his source along code ?

[VBA Noob]

Something like

Please Login or Register  to view this content.

link should be helpful

http://www.ozgrid.com/VBA/ExcelRanges.htm

VBA Noob

[matrixknow]

If you find the last cell in a column or row how can you get his position ?
Suppose (row20:column5) is the last cell before a blank how do I know that. I need to know the position. With this position I can say to format the cells from the first position to the last position. With the code below he only select the cell.

Please Login or Register  to view this content.