AW: Wie wär's denn damit, ...
05.06.2019 17:46:07
Klaus
Hier ist das Makro:
Sub CMR_Mitte_Hannover()
With Selection.Interior
.ColorIndex = 44
End With
For Each Item In Selection
ActiveCell.Offset(0, 0).Interior.ColorIndex = 44
ActiveCell.Offset(1, 0).Characters.Font.Bold = False
ActiveCell.Offset(1, 0).Value = "Ereignismeldung der CMR Mitte/Hannover vom " & Format(Now(), " _
dd.mm.yyyy hh:mm ") & "Uhr" & " Störfallnr.: N "
ActiveCell.Offset(1, 0).Characters.Font.Bold = True
ActiveCell.Offset(2, 0).Characters(Start:=1, Length:=21).Font.Bold = False
ActiveCell.Offset(2, 0).Value = "Zeitpunkt: Uhr"
ActiveCell.Offset(2, 0).Characters(Start:=1, Length:=21).Font.Bold = True
ActiveCell.Offset(3, 0).Characters(Start:=1, Length:=3).Font.Bold = False
ActiveCell.Offset(3, 0).Value = "Ort: "
ActiveCell.Offset(3, 0).Characters(Start:=1, Length:=3).Font.Bold = True
ActiveCell.Offset(4, 0).Characters(Start:=1, Length:=7).Font.Bold = False
ActiveCell.Offset(4, 0).Value = "Strecke: "
ActiveCell.Offset(4, 0).Characters(Start:=1, Length:=7).Font.Bold = True
ActiveCell.Offset(5, 0).Characters(Start:=1, Length:=8).Font.Bold = False
ActiveCell.Offset(5, 0).Value = "Ereignis: "
ActiveCell.Offset(5, 0).Characters(Start:=1, Length:=8).Font.Bold = True
ActiveCell.Offset(6, 0).Characters(Start:=1, Length:=7).Font.Bold = False
ActiveCell.Offset(6, 0).Value = "Schäden: "
ActiveCell.Offset(6, 0).Characters(Start:=1, Length:=7).Font.Bold = True
ActiveCell.Offset(7, 0).Characters(Start:=1, Length:=9).Font.Bold = False
ActiveCell.Offset(7, 0).Value = "Sonstiges: "
ActiveCell.Offset(7, 0).Characters(Start:=1, Length:=9).Font.Bold = True
ActiveCell.Offset(8, 0).Characters(Start:=1, Length:=23).Font.Bold = False
ActiveCell.Offset(8, 0).Value = "Auswirkung auf DB Cargo: "
ActiveCell.Offset(8, 0).Characters(Start:=1, Length:=23).Font.Bold = True
ActiveCell.Offset(9, 0).Characters(Start:=1, Length:=32).Font.Bold = False
ActiveCell.Offset(9, 0).Value = "Eingeleitete Maßnahmen CLZ/PZ/CZ: "
ActiveCell.Offset(9, 0).Characters(Start:=1, Length:=32).Font.Bold = True
ActiveCell.Offset(10, 0).Characters(Start:=1, Length:=17).Font.Bold = False
ActiveCell.Offset(10, 0).Value = "L.CBO 4-Maßnahmen: Auszug an KS "
ActiveCell.Offset(10, 0).Characters(Start:=1, Length:=17).Font.Bold = True
ActiveCell.Offset(11, 0).Interior.ColorIndex = 44
ActiveCell(1 + 1).Select
Next
'ActiveSheet.EnableAutoFilter = True
'ActiveSheet.Protect Password:="123", Contents:=True, userInterfaceOnly:=True
End Sub