大神,能解释一下代码什么意思吗?
(1)Private Sub Worksheet_Change(ByVal Target As Range)
Dim CL
If Target.Column < 7 Then
CL = Target.Column
DropList CL
End If
End Sub
(2)Sub DropList(C)
With Sheet1.DrawingObjects("下拉框 " & C)
.ListFillRange = "'数据源 '!" & Cells(2, C).Resize(Cells(1, C).End(4).Row - 1, 1).Address
.DropDownLines = 8
End With
End Sub
(3)Sub 提交()
With Sheets("统计表")
.Unprotect Password:="123"
If .Range("A65536").End(3).Row < 5 Then P = 5 Else P = 2
.Rows(3).Copy .Range("A65536").End(3)(P)
.Range("A65536").End(3)(P) = "=ROW()-4" '序号
.Rows(3).ClearContents
这个p是什么意思啊