Bitte, kann mir Jemand ein Macro Schreiben, das in der aktuellen Tabelle die in
Spallte c gezeichnete Kreise (Ellipsen) löscht.
Danke Darek
Sub EllipsenInCLoeschen()
' Starten in dem Tabellenblatt wo die Ellipsen gelöscht werden sollen
Dim shpEllipse As Shape
For Each shpEllipse In ActiveSheet.Shapes
If shpEllipse.AutoShapeType = msoShapeOval And _
shpEllipse.TopLeftCell.Column = 3 And _
shpEllipse.BottomRightCell.Column = 3 Then
shpEllipse.Delete
End If
Next shpEllipse
End Sub
Sub EllipsenInCUndDLoeschen()
' Starten in dem Tabellenblatt wo die Ellipsen gelöscht werden sollen
Dim shpEllipse As Shape
For Each shpEllipse In ActiveSheet.Shapes
If shpEllipse.AutoShapeType = msoShapeOval And _
(shpEllipse.TopLeftCell.Column = 3 Or shpEllipse.TopLeftCell.Column = 4) And _
(shpEllipse.BottomRightCell.Column = 3 Or shpEllipse.BottomRightCell.Column = 4) Then
shpEllipse.Delete
End If
Next shpEllipse
End Sub
Sub EllipsenInZeile1Loeschen()
' Starten in dem Tabellenblatt wo die Ellipsen gelöscht werden sollen
Dim shpEllipse As Shape
For Each shpEllipse In ActiveSheet.Shapes
If shpEllipse.AutoShapeType = msoShapeOval And _
shpEllipse.TopLeftCell.Row = 1 And _
shpEllipse.BottomRightCell.Row = 1 Then
shpEllipse.Delete
End If
Next shpEllipse
End Sub
Sub EllipsenInZeile1und2Loeschen()
' Starten in dem Tabellenblatt wo die Ellipsen gelöscht werden sollen
Dim shpEllipse As Shape
For Each shpEllipse In ActiveSheet.Shapes
If shpEllipse.AutoShapeType = msoShapeOval And _
(shpEllipse.TopLeftCell.Row = 1 Or shpEllipse.TopLeftCell.Row = 2) And _
(shpEllipse.BottomRightCell.Row = 1 Or shpEllipse.BottomRightCell.Row = 2) Then
shpEllipse.Delete
End If
Next shpEllipse
End Sub