Hello,
I want to get the data range of a table except the last three rows in the table. I know the code to choose the data range of the table is :
But how could I minus the last 3 rows?
Thank you!
Best regards,
lolo
I want to get the data range of a table except the last three rows in the table. I know the code to choose the data range of the table is :
Code:
ActiveSheet.ListObjects("Table1").DataBodyRange
But how could I minus the last 3 rows?
Thank you!
Best regards,
lolo