|
- <p>Private Sub Worksheet_Change(ByVal Target As Range)</p><p> Dim n%, ir%</p><p> ir = Target.Row</p><p> If Application.WorksheetFunction.CountA(Range(Cells(ir, "c"), Cells(ir, "t"))) = Columns("c:t").Count Then</p><p> If Cells(ir + 1, "b").End(xlUp).Row > 2 Then</p><p> Application.EnableEvents = False '表示禁用事件</p><p> Range("d1") = Cells(ir + 1, "b").End(xlUp)</p><p> Range("o1") = "TRM" & Format(Date, "YYMMDD") & "-" & Format(Application.WorksheetFunction.CountA(Range("b3:b" & ir)), "00")</p><p> Cells(ir, 1) = Application.WorksheetFunction.CountA(Range(Cells(3, "c"), Cells(ir, "c")))</p><p> Application.EnableEvents = True '表示不禁用事件</p><p> End If</p><p> End If</p><p>
- </p><p>End Sub</p>
复制代码
New picking list for ASSE.rar
(25.09 KB, 下载次数: 10)
|
|