The code I posted is for deleting all rows from the last row upwards in the second table in the document where the first formfield on each row is empty. It exits at the first non-empty row. It is not for deleting the 'current' row. Whilst the code could be modified to delete just the current row, what you need to figure out is how you're going to trigger the macro only when you know there are no data to add to that row. When you've figured that out, please post your query in a new thread rather than hijacking a thread dealing with a different issue.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|