need to append range name size with new entry automatically
 

I am transferring and old lotus program to excell. I
wrote macros in lotus that gave a range a name, then I
wrote an insert command which appended my sales data base
to include the new information. In excell I now how to
name my salesdata base, and to take my new information and
add it to the cells below my current data base, but my
problem is to automatically update the salesdata base to
include the new record. I can do it manually, but I need
to have the macro include a function to append or add the
new record. Thanks for any help. Don

need to append range name size with new entry automatically
 

You can use a Dynamic Range

Look at this example Don
http://www.contextures.com/xlNames01.html#Dynamic

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



" wrote in message
...
I am transferring and old lotus program to excell. I
wrote macros in lotus that gave a range a name, then I
wrote an insert command which appended my sales data base
to include the new information. In excell I now how to
name my salesdata base, and to take my new information and
add it to the cells below my current data base, but my
problem is to automatically update the salesdata base to
include the new record. I can do it manually, but I need
to have the macro include a function to append or add the
new record. Thanks for any help. Don