holycome99
New Member
- Joined
- Nov 16, 2020
- Messages
- 15
- Office Version
- 365
- Platform
- Windows
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.
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.