Range manipulation
 

Hi all,

I have couple of tables that can have many number of rows. The
number of rows can vary depending on the number of items that I need to
put into each table. The last row of the table is always will be "Total
and some number".

The work sheet contains may items and the above tables. The number of
tables could be anywhere from 1-5.

I am trying to generate a vba code that can copy only the tables from
this worksheet and then assort all the tables to new a worksheet with
an empty row in between the tables.

Is there a way to use range objects to get this done? How can we
specify a range object that is between the start of the table to the
end of the table?

Thanks in advance for all the suggestions.
shi

Range manipulation
 

I came to know that named ranges can be used to solve this kind of
problem. But I don't know how?