Sub countrownum() Dim i, num, rownum num = Worksheets.Count For i = 2 To num 'Worksheets(i).Select rownum = WorksheetFunction.CountA(Worksheets(i).Columns("a:a")) Sheets(1).Cells(i, 5) = rownum Next End Sub
本文共 266 字,大约阅读时间需要 1 分钟。
Sub countrownum() Dim i, num, rownum num = Worksheets.Count For i = 2 To num 'Worksheets(i).Select rownum = WorksheetFunction.CountA(Worksheets(i).Columns("a:a")) Sheets(1).Cells(i, 5) = rownum Next End Sub
转载地址:https://blog.csdn.net/youxianzide/article/details/81713823 如侵犯您的版权,请留言回复原文章的地址,我们会给您删除此文章,给您带来不便请您谅解!