so m?sste es gehen. Ist zwar eine Select mehr, aber immerhin!
Sub test()
MeinArray = Array("Tabelle1", "Tabelle2")
Worksheets(MeinArray).Select
ActiveSheet.Range("A:A").Select
Selection.EntireRow.Delete
End Sub
Marc
Sub test()
MeinArray = Array("Tabelle1", "Tabelle2")
Worksheets(MeinArray).Select
ActiveSheet.Range("A:A").Select
Selection.EntireRow.Delete
End Sub
Sub test()
MeinArray = Array("Tabelle1", "Tabelle2")
with Worksheets(MeinArray)
with .Range("A:A")
.EntireRow.Delete
end with
end with
End Sub
Sub test()
MeinArray = Array("Tabelle1", "Tabelle2")
Worksheets(MeinArray).Select
ActiveSheet.Range("A:A").Select
Selection.Delete
End Sub
Sub test()
MeinArray = Array("Tabelle1", "Tabelle2")
with Worksheets(MeinArray)
.Range("A:A").Delete
end with
End Sub
Sub test()
MeinArray = Array("Tabelle1", "Tabelle2")
Worksheets(MeinArray).Select
ActiveSheet.Range("A:A").Select
Selection.EntireRow.Delete
End Sub
Sub test()
MeinArray = Array("Tabelle1", "Tabelle2")
with Worksheets(MeinArray)
with .Range("A:A")
.EntireRow.Delete
end with
end with
End Sub
Sub test()
MeinArray = Array("Tabelle1", "Tabelle2")
Worksheets(MeinArray).Select
ActiveSheet.Range("A:A").Select
Selection.Delete
End Sub
Sub test()
MeinArray = Array("Tabelle1", "Tabelle2")
with Worksheets(MeinArray)
.Range("A:A").Delete
end with
End Sub