- 日志
- 好友
- 卖家信用
- 买家信用
- 注册时间
- 2004-12-22
- 在线时间
- 小时
|
发表于 2011-12-9 18:27:06
|
显示全部楼层
- 没有试验
- Sub Sample()
- Dim Rows As Long, Columns As Long,cnt As Long,m As Long,n As Long
- m = Selection.Rows.count
- n = Selection.Columns.count
- For Columns = 1 To n
- For Rows = 1 To m
- cnt = WorksheetFunction.CountIf(ActiveSheet.Range(Cells(1, Columns), Cells(m, Columns)), Cells(Rows, Columns))
- 这里输出cnt
- Next Rows
- Next Columns
- End Sub
复制代码 |
评分
-
查看全部评分
|