Hier nochmal der Code, ich habe die stelle (fast am ende) fett markiert.
Option Explicit
Dim sd As String
Dim ld As String
Sub Drucken_NEU()
Dim a As Integer
Dim l As Integer
Dim C As Range
Dim su As Integer
Application.ScreenUpdating = False
Worksheets("Aliste").Visible = True
Worksheets("Radmontage Formular").Visible = True
Worksheets("Felgen Aufkleber").Visible = True
Sheets("Aliste").Range("A2:J1000").ClearContents
Worksheets("overview").Activate
'Prüfen ob Druckerauswahl erfolgte wenn nicht Druckerauswahl
If (sd = "") Then
MsgBox "Bitte A4 Standarddrucker wählen"
Application.Dialogs(xlDialogPrinterSetup).Show
sd = Application.ActivePrinter
MsgBox "Bitte Labeldrucker auswählen"
Application.Dialogs(xlDialogPrinterSetup).Show
ld = Application.ActivePrinter
End If
Application.ActivePrinter = sd
l = 2
For Each C In Selection
su = 0
a = C.Row
If UCase(Worksheets("overview").Cells(a, 12).Value) = "X" Or UCase(Worksheets("overview"). _
Cells(a, 13).Value) = "X" Or UCase(Worksheets("overview").Cells(a, 14).Value) = "X" Or _
UCase(Worksheets("overview").Cells(a, 15).Value) = "X" Or UCase(Worksheets("overview"). _
Cells(a, 16).Value) = "X" Or UCase(Worksheets("overview").Cells(a, 17).Value) = "X" Or UCase(Worksheets("overview").Cells(a, 18).Value) = "X" Then
If UCase(Worksheets("overview").Cells(a, 8).Value) = "X" Then su = su + 1
If UCase(Worksheets("overview").Cells(a, 9).Value) = "X" Then su = su + 1
If UCase(Worksheets("overview").Cells(a, 10).Value) = "X" Then su = su + 1
If UCase(Worksheets("overview").Cells(a, 11).Value) = "X" Then su = su + 1
Worksheets("overview").Cells(a, 4) = su
If IsEmpty(C.Offset(0, 26).Value) Or IsEmpty(C.Offset(0, 28).Value) Then
If UCase(Worksheets("overview").Cells(a, 12).Value) = "X" Then
C.Offset(0, 26) = Cells(2, 12)
C.Offset(0, 27) = C.Offset(0, 0) & Cells(2, 12)
If UCase(Worksheets("overview").Cells(a, 19).Value) = "X" Then
C.Offset(0, 28) = Cells(2, 19)
C.Offset(0, 29) = C.Offset(0, 0) & Cells(2, 19)
Else
If UCase(Worksheets("overview").Cells(a, 20).Value) = "X" Then
C.Offset(0, 28) = Cells(2, 20)
C.Offset(0, 29) = C.Offset(0, 0) & Cells(2, 20)
Else
If UCase(Worksheets("overview").Cells(a, 21).Value) = "X" Then
C.Offset(0, 28) = Cells(2, 21)
C.Offset(0, 29) = C.Offset(0, 0) & Cells(2, 21)
Else
If UCase(Worksheets("overview").Cells(a, 22).Value) = "X" Then
C.Offset(0, 28) = Cells(2, 22)
C.Offset(0, 29) = C.Offset(0, 0) & Cells(2, 22)
Else
End If
End If
End If
End If
Else
If UCase(Worksheets("overview").Cells(a, 13).Value) = "X" Then
C.Offset(0, 26) = Cells(2, 13)
C.Offset(0, 27) = C.Offset(0, 0) & Cells(2, 13)
C.Offset(0, 28) = Cells(2, 13)
C.Offset(0, 29) = C.Offset(0, 0) & Cells(2, 13)
Else
If UCase(Worksheets("overview").Cells(a, 14).Value) = "X" Then
C.Offset(0, 26) = Cells(2, 14)
C.Offset(0, 27) = C.Offset(0, 0) & Cells(2, 14)
C.Offset(0, 28) = Cells(2, 14)
C.Offset(0, 29) = C.Offset(0, 0) & Cells(2, 14)
Else
If UCase(Worksheets("overview").Cells(a, 15).Value) = "X" Then
C.Offset(0, 26) = Cells(2, 15)
C.Offset(0, 27) = C.Offset(0, 0) & Cells(2, 15)
C.Offset(0, 28) = Cells(2, 15)
C.Offset(0, 29) = C.Offset(0, 0) & Cells(2, 15)
Else
If UCase(Worksheets("overview").Cells(a, 16).Value) = "X" Then
C.Offset(0, 26) = Cells(2, 16)
C.Offset(0, 27) = C.Offset(0, 0) & Cells(2, 16)
C.Offset(0, 28) = Cells(2, 16)
C.Offset(0, 29) = C.Offset(0, 0) & Cells(2, 16)
Else
If UCase(Worksheets("overview").Cells(a, 17).Value) = "X" Then
C.Offset(0, 26) = Cells(2, 17)
C.Offset(0, 27) = C.Offset(0, 0) & Cells(2, 17)
C.Offset(0, 28) = Cells(2, 17)
C.Offset(0, 29) = C.Offset(0, 0) & Cells(2, 17)
Else
If UCase(Worksheets("overview").Cells(a, 18).Value) = "X" Then
C.Offset(0, 26) = Cells(2, 18)
C.Offset(0, 27) = C.Offset(0, 0) & Cells(2, 18)
C.Offset(0, 28) = Cells(2, 18)
C.Offset(0, 29) = C.Offset(0, 0) & Cells(2, 18)
End If
End If
End If
End If
End If
End If
End If
End If
Worksheets("Aliste").Cells(l, 1) = Worksheets("overview").Cells(a, 1) 'Kennzeichen
Worksheets("Aliste").Cells(l, 2) = Worksheets("overview").Cells(a, 3) ' Satznummer
Worksheets("Aliste").Cells(l, 3) = Worksheets("overview").Cells(a, 28) 'Lagerpaltz
Worksheets("Aliste").Cells(l, 4) = Worksheets("overview").Cells(a, 2) 'Vin
Worksheets("Aliste").Cells(l, 5) = Worksheets("overview").Cells(a, 27) 'Termin
Worksheets("Aliste").Cells(l, 6) = Worksheets("overview").Cells(a, 29) 'Service
Worksheets("Aliste").Cells(l, 7) = Worksheets("overview").Cells(a, 8) 'VL
Worksheets("Aliste").Cells(l, 8) = Worksheets("overview").Cells(a, 9) 'VR
Worksheets("Aliste").Cells(l, 9) = Worksheets("overview").Cells(a, 10) 'HL
Worksheets("Aliste").Cells(l, 10) = Worksheets("overview").Cells(a, 11) 'HR
Worksheets("Radmontage Formular").Cells(13, 7) = Worksheets("overview").Cells(a, 1) ' _
Kennzeichen
Worksheets("Radmontage Formular").Cells(13, 5) = Worksheets("overview").Cells(a, 2) 'Vin
Worksheets("Radmontage Formular").Cells(9, 5) = Worksheets("overview").Cells(a, 3) ' _
Satznummer
Worksheets("Radmontage Formular").Cells(11, 5) = "*" & Worksheets("overview").Cells(a, 3) & _
"*" ' Satznummer code
Worksheets("Radmontage Formular").Cells(12, 5) = Worksheets("overview").Cells(a, 28) ' _
Lagerpaltz
Worksheets("Radmontage Formular").Cells(10, 5) = Worksheets("overview").Cells(a, 4) 'Menge
Worksheets("Radmontage Formular").Cells(14, 5) = Worksheets("overview").Cells(a, 27) ' _
Termin
Worksheets("Radmontage Formular").Cells(3, 1) = Worksheets("overview").Cells(a, 29) ' _
Service
Worksheets("Radmontage Formular").Cells(1, 9) = Worksheets("overview").Cells(a, 8) 'VL
Worksheets("Radmontage Formular").Cells(2, 9) = Worksheets("overview").Cells(a, 9) 'VR
Worksheets("Radmontage Formular").Cells(3, 9) = Worksheets("overview").Cells(a, 10) 'HL
Worksheets("Radmontage Formular").Cells(4, 9) = Worksheets("overview").Cells(a, 11) 'HR
Worksheets("Radmontage Formular").Cells(55, 1) = "*" & Worksheets("overview").Cells(a, 30) & _
"*" 'Service code
Worksheets("Radmontage Formular").Cells(14, 7) = Worksheets("overview").Cells(a, 26) ' _
Termin
Worksheets("Radmontage Formular").Cells(53, 1) = Worksheets("overview").Cells(a, 6) ' _
Bemerkung
Worksheets("Radmontage Formular").Cells(9, 7) = Date 'Datum
Sheets("Radmontage Formular").PrintOut Copies:=1
C.Interior.ColorIndex = 42
If UCase(Worksheets("overview").Cells(a, 12).Value) = "X" Then
Application.ActivePrinter = ld
Worksheets("Felgen Aufkleber").Cells(3, 1) = Worksheets("overview").Cells(a, 6) ' _
Bemerkung
Worksheets("Felgen Aufkleber").Cells(4, 2) = Worksheets("overview").Cells(a, 3) ' _
Satznummer
Worksheets("Felgen Aufkleber").Cells(6, 2) = Worksheets("overview").Cells(a, 28) ' _
Lagerpaltz
Worksheets("Felgen Aufkleber").Cells(5, 3) = ""
If Not IsEmpty(Worksheets("overview").Cells(a, 27)) Then Worksheets("Felgen Aufkleber"). _
Cells(5, 3) = Worksheets("overview").Cells(a, 27) - 5 'Termin
'Worksheets("Felgen Aufkleber").Cells(5, 3) = Worksheets("overview").Cells(a, 27) - 5 ' _
Termin
If UCase(Worksheets("overview").Cells(a, 8).Value) = "X" Then
Worksheets("Felgen Aufkleber").Cells(5, 2) = "VL"
Sheets("Felgen Aufkleber").PrintOut Copies:=4
End If
If UCase(Worksheets("overview").Cells(a, 9).Value) = "X" Then
Worksheets("Felgen Aufkleber").Cells(5, 2) = "VR"
Sheets("Felgen Aufkleber").PrintOut Copies:=4
End If
If UCase(Worksheets("overview").Cells(a, 10).Value) = "X" Then
Worksheets("Felgen Aufkleber").Cells(5, 2) = "HL"
Sheets("Felgen Aufkleber").PrintOut Copies:=4
End If
If UCase(Worksheets("overview").Cells(a, 11).Value) = "X" Then
Worksheets("Felgen Aufkleber").Cells(5, 2) = "HR"
Sheets("Felgen Aufkleber").PrintOut Copies:=4
End If
Application.ActivePrinter = sd
C.Interior.ColorIndex = 6
End If
End If
l = l + 1
Next
Worksheets("Aliste").PrintOut Copies:=1
Worksheets("Aliste").Visible = False
Worksheets("Radmontage Formular").Visible = False
Worksheets("Felgen Aufkleber").Visible = False
Application.ScreenUpdating = True
End Sub