How to calculate the row column in vba if there is 2 table in one sheet

[holycome99]

I have 2 table in a sheet now
I could calculate the row number of the first table easily as it is in the first column of my sheet so i can use

nextrec = Sheets("Chart Calculation").Cells(Rows.Count, 1).End(xlUp).Row + 1

But how about the another table?
The row number for the two table are not the same.
Thank you.

 

[My Aswer Is This]

If you are actually talking about a Table you need to use the Table Name
Here is a example:

Sub Count_Me()
'Modified 12/5/2020  12:40:49 AM  EST
Dim nextrec As Long
nextrec = Sheets(1).ListObjects("Table1").Range.Columns(1).Rows.Count
MsgBox nextrec
End Sub