copy/add row macro

[kvanb796]

I have a form which people are going to use to fill in quantity, description, and total for items they are purchasing.

I was able to create the macro for adding a row with no problem, but when I try to create the macro to copy the table it will start cutting off rows at the bottom if I add more rows first. Is there a way to avoid this?

This is my first time using macros, and I don't really know vb (I'm trying though!) Also, I am using Excel 2003.

Thanks so much!

[Simon Lloyd]

Welcome to Excel Forum!, to better explain why not attach a workbook, this is done by using the Manage Attachments button below your reply window, this way we can see your structure and help you directly.

[royUK]

Take a look at the databaseform example here

http://www.excel-it.com/vba_examples.htm

For help with your code try posting it, using Code Tags, or attach the workbook.

[solnajeff]

Hi

When you talk about adding rows to the table, do you mean a named range ?

If so there are a couple of ways to solve the problem, a dynamic named range which expands as you add data, or with a fixed range you need to make the range one row bigger at the top and then hide that row and then when adding rows, start from the second row and the range will expand as each row is added.

If you have a small example you can post it will be possible to make the changes for you to see.

Regards

Jeff