1-2013 auf 2-2013 und so weiter.
was muss ich tun um das umzusetzen?
Danke für eure Mühe
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Range("a1").Select
ActiveCell.FormulaR1C1 = ActiveCell.Value + 1
Range("B1").Select
End Sub
Sub Keno_Drucken()
Dim wksSchein As Worksheet, Zaehler As Long
If MsgBox("Keno-Scheine 1 bis 50 drucken?", vbQuestion + vbYesNo, "Drucken KENO-Scheine") = _
_
vbYes Then
Set wksSchein = ActiveSheet
With wksSchein
For Zaehler = 1 To 50
Application.StatusBar = "Schein Nummer " & Zaehler & " wird gedruckt"
.Range("AS3").Value = Zaehler
.Calculate
.PrintOut
Next
Application.StatusBar = False
.Range("AS3").Value = 1
End With
End If
End Sub
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Range("E3") = CLng(Left(Range("E3"), InStr(1, Range("E3"), "-") - 1)) + 1 & Right(Range("E3"), _
5)
End Sub