VBA and copying tables

I have some VBA that copies the contents of a Table from one worksheet to another, and pastes it as values to function as a back-up file for the original spreadsheet.

I am now trying to write more VBA to take the values from the back-up and copy them to yet another file. It will function as a restored file.

I am using the following format to copy everything else and need to know how to enter the range when I don't know how many rows the table will be.

Please Login or Register  to view this content.

Is there some sort of COUNT feature that I can use to capture as many lines as the user may have entered on the original table?

Does that make sense? I am using Excel 2016.

Thanks!

Please Login or Register  to view this content.

Perfect! Thank you so much!

You are welcome, glad I could be of some help
If you are satisfied, please mark the thread as SOLVED!!!