end of a pivod table

  • Thread starter Thread starter vish
  • Start date Start date
V

vish

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
 
vish,

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

HTH,
Bernie
MS Excel MVP
 
Back
Top