Excel VBA 编程,在表格做自动筛选的功能
下面的例子是自动筛选85列的内容,筛选内容为处方
Private Sub CommandButton11_Click()
'筛选处方
If Sheet1.AutoFilterMode = False Then '检查是否开启自动筛选
lastrow = Sheet1.Range("A1040000").End(xlUp).Row
Range("A:DZ").AutoFilter '没有开启的话则开启自动筛选
Sheet1.Range("CG:CG").AutoFilter field:=85, Criteria1:="处方"
Else
Sheet1.AutoFilterMode = False
lastrow = Sheet1.Range("A1040000").End(xlUp).Row
Range("A:DZ").AutoFilter '没有开启的话则开启自动筛选
Sheet1.Range("CG:CG").AutoFilter field:=85, Criteria1:="处方"
End If
End Sub
Private Sub CommandButton11_Click()
'筛选处方
If Sheet1.AutoFilterMode = False Then '检查是否开启自动筛选
lastrow = Sheet1.Range("A1040000").End(xlUp).Row
Range("A:DZ").AutoFilter '没有开启的话则开启自动筛选
Sheet1.Range("CG:CG").AutoFilter field:=85, Criteria1:="处方"
Else
Sheet1.AutoFilterMode = False
lastrow = Sheet1.Range("A1040000").End(xlUp).Row
Range("A:DZ").AutoFilter '没有开启的话则开启自动筛选
Sheet1.Range("CG:CG").AutoFilter field:=85, Criteria1:="处方"
End If
End Sub