RowsCount

Get total number of rows for a certain worksheet in certain workbook
workbook needs to be open
Needed to get to know if this workbook is in XLS format (65k rows) or in xlsx format (1m rows).

CodeFunctionName
What is this?

Public

Tested

Original Work
Function RowsCount(Optional Shee = "This", optional Wb = "This")
If Wb = "This" Then Wb = ThisWorkbook.Name
If Shee = "This" Then Shee = Workbooks(Wb).Worksheets(1).Name
RowsCount = Workbooks(Wb).Worksheets(Shee).Range("A1").EntireColumn.Rows.Count
End Function

Optional Shee, optional Wb

Views 3,531

Downloads 1,303

CodeID
DB ID

ANmarAmdeen
602
Revisions

v1.0

Friday
June
22
2018