|
发表于 2015-1-7 16:44
|
显示全部楼层
本楼为最佳答案
Sub Click()
Dim A, i%, j%, x$, r%, c%
Application.ScreenUpdating = False
'1)指定
x = Application.InputBox("两位数:", "输入")
If x = False Or Len(x) <> 2 Or VBA.IsNumeric(x) = False Then End
x = CStr(x)
'2)查询
A = Range("a1").CurrentRegion
r = UBound(A): c = UBound(A, 2)
For j = 1 To c
For i = 1 To r
If x <> Right(A(i, j), 2) Then A(i, j) = ""
Next i
Next j
'3)输出
Sheets(2).Activate
Range("a1").CurrentRegion.ClearContents
Range([a1], Cells(r, c)) = A
Range([a1], Cells(r, c)).SpecialCells(xlCellTypeBlanks).Delete xlShiftUp
End Sub
提数附件2.rar
(41.07 KB, 下载次数: 6)
|
评分
-
查看全部评分
|