文章列表
最近帮一个朋友求助，问能不能把excel里某一列的时间钟，把大于一个时间的单元格标记出来。有一个参考时间，从参考时间算起往后数3天，遇到节假日自动顺延。
代码如下
Private Sub Workbook_Open()
Dim rng1 As Range
Dim rng2 As Range
Dim i As Integer
Dim flag As Boolean
Dim j As Integer
Dim allrows As Integer
Dim tempDate As Date
Dim validateDates(1 To 3) As Date
Dim ...