I have a VBA macro that moves the rows down after data entered and I press Enter key. I want to limit the range of movement.


In my example, after I entered the data rows are moved down, but I do not want that after moving all data is visible.
I want to value or data in the last row disappears and in its place came second last, and so on each following.
I also want to limit the VBA macro only the data range A1:G10. At any time, it is evident only 10 rows
Another problem is if I make a mistake when entering data. Is there a possibility to create VBA UNDO (or have some copy all data to another Sheet in the moment the entering entry, when I press Enter key)
Can someone help me.

Attached Files

move-down.xlsm (247.9 KB, 9 views)

That requires nothing more than adding:
Rows(11).EntireRow.Delete
before:
Application.EnableEvents = True

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]