Range manipulation

  • Thread starter Thread starter shishi
  • Start date Start date
S

shishi

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
 
I came to know that named ranges can be used to solve this kind of
problem. But I don't know how?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reposting to get some answers...... 1
VBA - retrieve data on last create named range from previous inserted named range 0
Excel Moving data to sheet2 from sheet1 0
Variable Range, selecting/copying 1
Ron de Bruin - Merge cells from all worksheets 0
How can I use range objects to solve this problem 1
Resize a Table using VBA 9
Need Excel Macro to select an unknown, named table and convert it toa range 1

Back
Top