Question

vb中如何返回excel的行数

在vb中，我想知道EXCEL有多少行，用什么函数呢？

Answer 1

worksheet1.UsedRange.Rows.Count

Answer 2

With ActiveSheet.UsedRange
x = .Cells(.Rows.Count, .Columns.Count).Row
y = .Cells(.Rows.Count, .Columns.Count).Column
End With

Answer 3

http://topic.csdn.net/t/20060710/15/4870962.html

Answer 4

[A65536].End(xlUp).Row