- 博客(2)
- 资源 (4)
- 收藏
- 关注
原创 汇总各表数据至主表
<br />Sub 按钮2_Click() Dim sht As Worksheet Dim rng As Range Dim a%, i% For Each sht In Sheets If sht.Name <> "主表" Then If IsEmpty(sht) = False Then a = sht.Range("B65536").End(xlUp).Row
2011-01-17 20:25:00 593
原创 计算加权平均-vba
Sub 计算加权() Dim rng As Range Dim sht As Worksheet Dim a%, b%, k%, i%, j% For Each sht In Sheets a = 5 For Each rng In sht.Range("H6:H469") If IsEmpty(rng) = True Then b = rng.Row
2011-01-17 15:21:00 1765
VBA 高级开发指南
2010-02-01
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人