|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub tb()
- '填表
- Set ITM = ListView1.ListItems.Add()
- ITM.Text = Format(Sht1.Cells(ii, 1), "mmm-yy")
- ITM.SubItems(1) = Sht1.Cells(ii, 3)
- ITM.SubItems(2) = Sht1.Cells(ii, 5)
- ITM.SubItems(3) = Sht1.Cells(ii, 7)
- ITM.SubItems(4) = Sht1.Cells(ii, 8)
- ITM.SubItems(5) = Sht1.Cells(ii, 9)
- ITM.SubItems(6) = Sht1.Cells(ii, 10)
- ITM.SubItems(7) = Sht1.Cells(ii, 11)
- ITM.SubItems(8) = Sht1.Cells(ii, 12)
- ITM.SubItems(9) = Sht1.Cells(ii, 14)
- ITM.SubItems(10) = Sht1.Cells(ii, 16)
- ITM.SubItems(11) = Sht1.Cells(ii, 17)
- ITM.SubItems(12) = Sht1.Cells(ii, 22)
- ITM.SubItems(13) = Sht1.Cells(ii, 27)
- ITM.SubItems(14) = Sht1.Cells(ii, 28)
- ITM.SubItems(15) = Sht1.Cells(ii, 30)
- total = total + Sht1.Cells(ii, 12).Value
- End Sub
复制代码 |
|