![]() |
#1
|
|||
|
|||
![]()
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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Move pst location? | markg2 | Outlook | 0 | 06-29-2013 11:00 AM |
How to move Office? | crochetdiva | Office | 1 | 11-29-2012 09:31 PM |
Delete option greyed out when trying to delete row 1 | tpcervelo | Excel | 2 | 11-15-2011 06:48 AM |
delete email message via blackberry and have it delete on my pop3 and my outlook | Iamthestorm | Outlook | 2 | 10-28-2010 12:21 AM |
Can't delete or move some contacts | Froglips | Outlook | 0 | 09-22-2007 05:42 AM |