end of a pivod table
 

hi,

how do i get the edge of a pivot table in a VBA so that
when run my next pivot table macro the new table does not
overlap on the previous one .

Thanx

end of a pivod table
 

vish,

ActiveSheet.PivotTables("PivotTable1").PivotSelect "", xlDataAndLabel
MsgBox "The first row below the PT is " & Selection.Row +
Selection.Rows.Count

HTH,
Bernie
MS Excel MVP
"vish" wrote in message
...
hi,

how do i get the edge of a pivot table in a VBA so that
when run my next pivot table macro the new table does not
overlap on the previous one .

Thanx