Range Problem
Ringlstetter
ich hab mal eine kleine Frage. Bei meinem Makro soll das aktive Feld nachdem alles fertig ist "a5" sein. Eigentlich hab ich das auch so geschrieben. Leider markiert Excel die Range "b12:e13"..kann mir jemand sagen warum?
Hier das Makro:
Sub Löschen()
' Löschen Makro
Dim Wert
Wert = Application.InputBox("Bitte geben Sie den Datumsbereich ein:", "Datumseingabe")
Dim wks
For Each wks In Sheets(Array("Fischer", "Rathje", "Kock", "Szewczyk", "Voss", "Böge", " _
FreierHelmut", _
"Schnoor", "Lubanski", "Horree", "Lütt", "Klein", "Krüger", "Hinrichsen", "Kinne", _
"Jensen", "Michalewski", "Dunker", "Stöckel", "Mumm", "Altenburg Rolf", "Lindemann", _
"Bartsch", "Kühl", "Kursel"))
wks.Range("A2:N2").Value = "Abrechnungszeitraum " & Wert
Next
Dim wksa
For Each wksa In Sheets(Array("BernhardtLeo", "Kath", "Kummerfeldt", "Holst", "Altenburg _
Andreas", _
"Groth", "Ramm", "Hammer", "Seider", "Latzel", "Maschmann", "Bernhard Knut", "Kramer", _
_
_
_
"Biernacki", "Gloyer", "Bergagnin", "Wollenberg", "Johannsen", "Grahlmann", _
"Stojanovic", "Farkas", "Lüben", "FreierThomas", "Bökenhauer", "Grothkopp"))
wksa.Range("A2:N2").Value = "Abrechnungszeitraum " & Wert
Next
Dim wksb
For Each wksb In Sheets(Array("Wegner", "Krause", "Schlünzen", "SpotaValerie", "Fröck", " _
Kuhn", _
"Meyer", "Neinstell", "Stahlschmidt", "Zabel", "Wulf", "Staben", "Völkel", "Greve", _
"Vogel", "Lang", "Kamp", "Grube", "Rütz", "Fuhrmann", "Mauer", "Losch", "Weiss", _
"Peters", "Pahl", "Willomeit"))
wksb.Range("A2:N2").Value = "Abrechnungszeitraum " & Wert
Next
If vbYes = MsgBox("Sicher? Dies löscht alle Daten!!!", _
vbYesNo + vbExclamation, "Nachfrage...") Then
Sheets("Fischer").Select
ActiveWindow.ScrollWorkbookTabs Position:=xlLast
Sheets(Array("Fischer", "Rathje", "Kock", "Szewczyk", "Voss", "Böge", "FreierHelmut", _
"Schnoor", "Lubanski", "Horree", "Lütt", "Klein", "Krüger", "Hinrichsen", "Kinne", _
"Jensen", "Michalewski", "Dunker", "Stöckel", "Mumm", "Altenburg Rolf", "Lindemann", _
"Bartsch", "Kühl", "Kursel")).Select
Sheets("Fischer").Activate
Sheets(Array("BernhardtLeo", "Kath", "Kummerfeldt", "Holst", "Altenburg Andreas", _
"Groth", "Ramm", "Hammer", "Seider", "Latzel", "Maschmann", "Bernhard Knut", "Kramer", _
_
_
_
"Biernacki", "Gloyer", "Bergagnin", "Wollenberg", "Johannsen", "Grahlmann", _
"Stojanovic", "Farkas", "Lüben", "FreierThomas", "Bökenhauer", "Grothkopp")).Select _
Replace:=False
Sheets(Array("Wegner", "Krause", "Schlünzen", "SpotaValerie", "Fröck", "Kuhn", _
"Meyer", "Neinstell", "Stahlschmidt", "Zabel", "Wulf", "Staben", "Völkel", "Greve", _
"Vogel", "Lang", "Kamp", "Grube", "Rütz", "Fuhrmann", "Mauer", "Losch", "Weiss", _
"Peters", "Pahl")).Select Replace:=False
Sheets("Willomeit").Select Replace:=False
Range("A5:O72").Select
Selection.ClearContents
End If
Range("a5").Select
Sheets("Menu").Select
Range("e13").Select
End Sub