Hi,

I am pretty new to excel programming. I don't know if this is
possible.. I have defined a name like START_TABLE at the begining of a
table in excel and END_TABLE at the end as below.
---------------
| START_TABLE |
---------------
------------------------------------
|------- THE TABLE GOES HERE ---|
-------------------------------------
-----------------
| END_TABLE |
-----------------

This table can grow in number of rows. But I need to copy this table to
another worksheet. So I am trying to define a named cell like
START_TABLE at the start and END_TABLE at the end. Then trying to get
the address for the START_TABLE and the END_TABLE, then define a range
using those cell addresses. Is this a good approach? How can I get the
address for a named cell(is it START_TABLE.Address)?

Thanks
shi