weis jemand wie man die Aktive Zeilen bei Doppelklick "nur Inhalt" automatisch löschen kann?
Danke
Gruß Lea
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Target.ClearContents
End Sub
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Rows(Target.Row).ClearContents
Cancel = True
End Sub
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Range("A" & Target.Row & ":O" & Target.Row).ClearContents
Cancel = True
End Sub