JimS
04-01-2011, 09:41 AM
Does anyone have any idea on how to select a Range for rows begin with the first row after the last row of a Pivot Table using VBA.
The Pivot Table changes size (rows) dependng on the data points and I need to select and range of rows automatically. The range would end at row 2000; getting the starting row is what I need the VBA to do.
Also, the Pivot Table does not start in Row 1 or Column 1, it's down and over a few rows and columns, if that's important.
Thanks for any help...
JimS
The Pivot Table changes size (rows) dependng on the data points and I need to select and range of rows automatically. The range would end at row 2000; getting the starting row is what I need the VBA to do.
Also, the Pivot Table does not start in Row 1 or Column 1, it's down and over a few rows and columns, if that's important.
Thanks for any help...
JimS