I realize that this is probably a duplicate, but I've been searching for an hour and I can't to get the syntax right. I have a sheet with several tables. There is at least one empty column and one empty row between one table to the other.

I know the start row and start column of each table, and I know that each table has 3 columns. I don't know how many rows it has.

I want to write a sub that receives:

1. table start row

2. table start column

and copies the table into another sheet (let's say that the destination is sheet2 starting at A1).

I know I can do it with a loop, but I suspect there is a better syntax right? (The main issue here is that I need to find the number of rows each table has)

Thanks. Li