insert=Name=Define

Name: List2 for example of a name you could use
Refersto: =Offset(Sheet1!$a$1,0,0,CountA(sheet1!$A:$A),10)

as an example. Adjust 10 to reflect the number of columns.

--
Regards,
Tom Ogilvy

"shishi" wrote in message
ups.com...
Hi FSt1 & Tom,

Thanks for your reply. I wish to ask you how can we use named range
to specify a number of rows when the number of rows change. The whole
idea is something like this.

I have an excel document with couple of lines of text and then a
table, then couple of lines of text and then table and so on. I wish to
specify a named range for the table. But I don't know how? Then I wish
to copy all the tables to another worksheet with a space between
tables. I wish to use the same program even when the number of rows in
the table increase or decrease. Since I don't know the excel
programming I find a lot of difficulty. Thanks a lot for your
suggestions.
shi