Private Sub Worksheet_PivotTableBeforeprint(ByVal TargetPivotTable As PivotTable, ByVal ValueChangeStart As Long, ByVal ValueChangeEnd As Long, Cancel As Boolean)
Sheets("sheet2").Range("a1") = Sheets("sheet2").Range("a1") + 1
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Sheets("sheet2").Range("a1") = 0 Then
Sheets("sheet1").Range("i5") = "GS" & Format(Now(), "yyyymmdd") & Format(Sheets("sheet2").Range("a1") + 1, "000")
Sheets("sheet2").Range("a1") = Sheets("sheet2").Range("a1") + 1
End If
End Sub gaosen.zip(19.12 KB, 下载次数: 32)