我要提取这个月的值,来生成生日名单,代码如下:
Sub birthdaylist()
With sheets2
End With
For i = 4 To 200
If Cells(i, 3) = "" Then
Exit Sub
Else
If Mid(Cells(i, 40), 11, 2) = Month(today()) Then
t = 9
p0 = Cells(i, 3)
With sheets1
End With
Cells(t, 5) = p0
t = t + 1
End If
End If
Next
End Sub
都不知道你代码 写的什么乱七八糟,
VBA 写成这样 还不如直接用公式
追答Sub brithdatlist()