请老师们给我修改个统计非空数的代码: Sub 郑文化次数vba()
Dim i&
For i = 9 To Sheet1.[a65536].End(xlUp).Row
Cells(i, 30) = "=counta(Cells(i, 15),(Cells(i, 16),(Cells(i, 17),(Cells(i, 18),(Cells(i, 19),(Cells(i, 20),(Cells(i, 21),(Cells(i, 22),(Cells(i, 23)(Cells(i, 24),(Cells(i, 25),(Cells(i, 26) (Cells(i, 27) "
Next
End Sub
这个意思?{:4512:}
- Sub 郑文化次数vba()
- Dim i&
- For i = 9 To Sheet1.[a65536].End(xlUp).Row
- Cells(i, 30) = WorksheetFunction.CountA(Range(Cells(i, 15), Cells(i, 27)))
- Next
- End Sub
复制代码
|