指定Sheet并获取Sheet的行数

2018-06-17 本文已影响0人 norman1981

Dim sh As Worksheet
Dim rowCount As Long

Set sh = Worksheets("汇总")
rowCount = sh.UsedRange.Rows.Count