Hi Amy
See this page
http://www.rondebruin.nl/copy1.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Amy" wrote in message ...
I have a form that after it is filled out I would like to transfer the
information (with a macro button) into an ongoing list on another page. Can I
program a macro to paste the information on the worksheets next available
line since this number will change everytime I use it as the list grows
larger with every entry?