Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-16-2014, 04:39 AM
beginner beginner is offline Move down row and delete last row Windows 7 32bit Move down row and delete last row Office 2007
Advanced Beginner
Move down row and delete last row
 
Join Date: Sep 2011
Location: Europe
Posts: 45
beginner will become famous soon enough
Question Move down row and delete last row

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
File Type: xlsm move-down.xlsm (247.9 KB, 9 views)
Reply With Quote
 



Similar Threads
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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:11 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft