VBA: Counting rows in a table (list object) VBA: Counting rows in a table (list object) vba vba

VBA: Counting rows in a table (list object)


excel vba

You need to go one level deeper in what you are retrieving.

Dim tbl As ListObjectSet tbl = ActiveSheet.ListObjects("MyTable")MsgBox tbl.Range.Rows.CountMsgBox tbl.HeaderRowRange.Rows.CountMsgBox tbl.DataBodyRange.Rows.CountSet tbl = Nothing

More information at:

ListObject Interface
ListObject.Range Property
ListObject.DataBodyRange Property
ListObject.HeaderRowRange Property

excel vba

You can use this:

    Range("MyTable[#Data]").Rows.Count

You have to distinguish between a table which has either one row of data or no data, as the previous code will return "1" for both cases.Use this to test for an empty table:

    If WorksheetFunction.CountA(Range("MyTable[#Data]"))

excel vba

You can use:

Sub returnname(ByVal TableName As String)MsgBox (Range("Table15").Rows.count)End Sub

and call the function as below

Sub called()returnname "Table15"End Sub

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last