Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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: 42
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, 1 views)
Reply With Quote
  #2  
Old 04-01-2014, 06:16 PM
macropod's Avatar
macropod macropod is offline Move down row and delete last row Windows 7 32bit Move down row and delete last row Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,052
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default

That requires nothing more than adding:
Rows(11).EntireRow.Delete
before:
Application.EnableEvents = True
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 12:53 AM.


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