L10 = Überschrift der Pivot
L11 = Der erste Datensatz
Danke für eure Hilfe!
Cells(rows.count, "L").end(xlup)
Sub Makro1()
With ActiveSheet.PivotTables("PvtMitVba")'PivotTables- Name anpassen
lz = Cells(Rows.Count, 1).End(xlUp).Row 'ev. Spalten Nr. anpassen
End With
End Sub
With Tabelle2.PivotTables("PivotTable1").DataBodyRange
n = .Cells(.Cells.Count).Row
End With
With Tabelle2.PivotTables("PivotTable1").DataBodyRange
.Cells(.Cells.Count).Select
End With
With Tabelle4.PivotTables("PivotTable1").DataBodyRange
n = .Cells(.Cells.Count).Row
Debug.Print n
'oder so:
n = .SpecialCells(xlCellTypeLastCell).Row
Debug.Print n
End With
Gruß von Luschi